SQL 查询两个数据库表的字段名的差异

SELECT * FROM
(
 SELECT B.NAME FROM SYSOBJECTS A
 LEFT JOIN SYSCOLUMNS B
 ON A.ID = B.ID
 WHERE A.NAME = '表名1'
) SS
WHERE NAME NOT IN
(
 SELECT B.NAME FROM SYSOBJECTS A
 LEFT JOIN SYSCOLUMNS B
 ON A.ID = B.ID
 WHERE A.NAME = '表名2'
)
原文地址:https://www.cnblogs.com/mishy/p/1821178.html