with the script you provided I need to check for every table in the database..and there are more than 100 tables....it will be a very complicated and time taking...could you...

I want to check if they have same column names and if their data type is same

hi,

I cannot use the redgate and all...what i was asked to do is to copy all the tables in a database into a temp table and then do the same...