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
比较两个数据库字段与表的差异
© 版权声明
文章版权归作者所有,若需转载,请在显著位置标志该文章地址。