你可以在数据库中Join一下,很多数据库都提供了多数据库访问功能
如SQLSERVER的OPENROWSET(
例
Select A.IDXType A_IDXType,A.IDXName A_IDXName,A.FieldName A_FieldName,A.TableName A_TableName,B.IDXType B_IDXType,B.IDXName B_IDXName,B.FieldName B_FieldName,B.TableName B_TableName from ( Select C.xtype as IDXType, C.[name] As IDXName,E.Name As FieldName,F.name As TableName From (Select xtype,[name],[parent_obj] From sysobjects Where 1=1 or xtype = 'PK' or xtype ='IK') C Join (Select B.Name,A.colid From sysindexkeys A Join sysindexes B On A.indid = B.indid And A.ID = B.ID ) D On C.[name] = D.[name] Join syscolumns E On C.parent_obj = E.id And D.colid = E.colid Join sysobjects F on C.parent_obj = F.id And F.xtype = 'U' ) as A FULL OUTER JOIN OPENROWSET('SQLOLEDB','SERVERDB';'dev';'dev001',' Select C.XType as IDXType, C.[name] As IDXName,E.Name As FieldName,F.name As TableName From (Select xtype,[name],[parent_obj] From HCCSCMDEV.DBO.sysobjects Where 1=1 or xtype = ''PK'' or xtype =''IK'') C Join (Select B.Name,A.colid From HCCSCMDEV.DBO.sysindexkeys A Join HCCSCMDEV.DBO.sysindexes B On A.indid = B.indid And A.ID = B.ID ) D On C.[name] = D.[name] Join HCCSCMDEV.DBO.syscolumns E On C.parent_obj = E.id And D.colid = E.colid Join HCCSCMDEV.DBO.sysobjects F on C.parent_obj = F.id And F.xtype = ''U'' ') as B ON a.tablename=b.tablename and a.idxtype=b.idxtype and A.IDXName=B.IDXName and a.fieldname = b.fieldname WHERE A.fieldname is null or B.FieldName is Null