[转载]不同库表间(含字段)比较的SQL代码
<p>信息来源:Unknow</p><p>use accdb1 --为zy旧库,Accdb为液晶版标准库,已知Accdb库比Accdb1库多出表和字段,求多出的表和字段<br /><br />SELECT accdb.table_name AS accdb_table_name, <br /> accdb.columns_name AS accdb_columns_name, <br /> accdb1.table_name AS accdb1_table_name, <br /> accdb1.columns_name AS accdb1_columns_name<br />FROM (SELECT Accdb.dbo.sysobjects.name AS table_name, <br /> Accdb.dbo.syscolumns.name AS columns_name<br /> FROM Accdb.dbo.syscolumns INNER JOIN<br /> Accdb.dbo.sysobjects ON <br /> Accdb.dbo.syscolumns.id = Accdb.dbo.sysobjects.id<br /> WHERE (NOT (Accdb.dbo.syscolumns.name LIKE <a href="mailto:'@%'">'@%'</a>)) AND <br /> (Accdb.dbo.sysobjects.xtype = 'U')) accdb LEFT OUTER JOIN<br /> (SELECT sysobjects.name AS table_name, <br /> syscolumns.name AS columns_name<br /> FROM syscolumns INNER JOIN<br /> sysobjects ON syscolumns.id = sysobjects.id<br /> WHERE (NOT (syscolumns.name LIKE <a href="mailto:'@%'">'@%'</a>)) AND (sysobjects.xtype = 'U')) <br /> accdb1 ON accdb.columns_name = accdb1.columns_name AND <br /> accdb.table_name = accdb1.table_name<br />WHERE (accdb1.table_name IS NULL) OR<br /> (accdb1.columns_name IS NULL) order by accdb.table_name,accdb.columns_name</p>页:
[1]