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