比较两个数据库字段与表的差异

select * from (
 select  b.TABLE_NAME+'.'+b.COLUMN_NAME as lie2 
 from UltimusBusiness.INFORMATION_SCHEMA.COLUMNS b 
 except
 select  a.TABLE_NAME+'.'+a.COLUMN_NAME as lie1
 from   UltimusBusiness1.INFORMATION_SCHEMA.COLUMNS a) c where c.lie2 not like '%BAK%' order by c.lie2

 

posted @ 2020-09-14 15:32  积山海  阅读(326)  评论(0编辑  收藏  举报