对比两张表中不一致的字段

对比两张表中不一致的字段（名称、类型、长度）
SELECT *
FROM (SELECT NAME,XTYPE,LENGTH FROM syscolumns s WHERE id=object_id('TABLE_A')) A
FULL JOIN (SELECT NAME,XTYPE,LENGTH FROM syscolumns s WHERE id=object_id('TABLE_B')) B ON A.NAME=B.NAME
WHERE ISNULL(A.NAME,'')<>ISNULL(B.NAME,'') OR ISNULL(A.XTYPE,'')<>ISNULL(B.XTYPE,'') OR ISNULL(A.LENGTH,0)<>ISNULL(B.LENGTH,0)

转载于:https://www.cnblogs.com/xiaojianblogs/p/9824991.html