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'
)
(
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'
)