select column_name from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='Table_name1'
except
select column_name from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='Table_name2'
where TABLE_NAME='Table_name1'
except
select column_name from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='Table_name2'
No comments:
Post a Comment