use accdb1 --為zy舊庫,Accdb為液晶版標(biāo)準(zhǔn)庫,已知Accdb庫比Accdb1庫多出表和字段,求多出的表和字段
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
更多文章、技術(shù)交流、商務(wù)合作、聯(lián)系博主
微信掃碼或搜索：z360901061
微信掃一掃加我為好友
QQ號聯(lián)系： 360901061
您的支持是博主寫作最大的動(dòng)力，如果您喜歡我的文章，感覺我的文章對您有幫助，請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點(diǎn)擊下面給點(diǎn)支持吧，站長非常感激您！手機(jī)微信長按不能支付解決辦法：請將微信支付二維碼保存到相冊，切換到微信，然后點(diǎn)擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對您有幫助就好】元
