--查询数据库DPII中含['Org_ID','Client_ID','Sender_ID','Receiver_ID','Vendor_Id']字段的表 use DPII GO SELECT o.[name]as tname, c.[name]as fname, c.length, t.[name]as type from dbo.sysobjects o innerjoin dbo.syscolumns c on o.id=c.id and c.[name]in ('Org_ID','Client_ID','Sender_ID','Receiver_ID','Vendor_Id') leftjoin dbo.systypes t on c.xtype=t.xusertype where o.xtype='U'and o.status>0