iphone6s国行型号:如何找出SQL数据库中两个数据库中表名称不同的记录?

来源:百度文库 编辑:杭州交通信息网 时间:2024/04/29 03:06:35
比如SQL2000中现在有Data1和Data2两个数据库,什么语句可以找出在两个数据库中表名称在彼此数据库中不存在的表名称?

SELECT accdb.table_name AS accdb_table_name,
accdb.columns_name AS accdb_columns_name,
accdb1.table_name AS accdb1_table_name,
accdb1.columns_name AS accdb1_columns_name
FROM (SELECT Accdb.dbo.sysobjects.name AS table_name,
Accdb.dbo.syscolumns.name AS columns_name
FROM Accdb.dbo.syscolumns INNER JOIN
Accdb.dbo.sysobjects ON
Accdb.dbo.syscolumns.id = Accdb.dbo.sysobjects.id
WHERE (NOT (Accdb.dbo.syscolumns.name LIKE '@%')) AND
(Accdb.dbo.sysobjects.xtype = 'U')) accdb LEFT OUTER JOIN
(SELECT sysobjects.name AS table_name,
syscolumns.name AS columns_name
FROM syscolumns INNER JOIN
sysobjects ON syscolumns.id = sysobjects.id
WHERE (NOT (syscolumns.name LIKE '@%')) AND (sysobjects.xtype = 'U'))
accdb1 ON accdb.columns_name = accdb1.columns_name AND
accdb.table_name = accdb1.table_name
WHERE (accdb1.table_name IS NULL) OR
(accdb1.columns_name IS NULL) order by accdb.table_name,accdb.columns_name

其中accdb1为旧库,accdb为新库。
不只能查出表不同, 还包括字段的