Create table #nik ( table_Name Varchar(300), Column_Name Varchar(300) ) Create Table #Temp ( Table_Name Varchar(300) ) Insert Into #nik Select TABLE_NAME ,Column_Name From dbName.Information_Schema.columns Where Column_Name Not IN (Select Column_Name From dbName2.Information_Schema.columns) Select * From #nik Select * From #nik Where table_Name Not in (Select table_Name from #Temp) Insert Into #Temp Values('Table') Select * From #Temp
No comments:
Post a Comment