)

4、外键

select t1.name,t2.rtableName,t2.name

from

(select col.name, f.constid as temp

from syscolumns col,sysforeignkeys f

where f.fkeyid=col.id

and f.fkey=col.colid

and f.constid in

( select distinct(id)

from sysobjects

where OBJECT_NAME(parent_obj)='YourTableName'

and xtype='F'

)

) as t1 ,

(select OBJECT_NAME(f.rkeyid) as rtableName,col.name, f.constid as temp

from syscolumns col,sysforeignkeys f www.2cto.com

where f.rkeyid=col.id

and f.rkey=col.colid

and f.constid in

( select distinct(id)

from sysobjects

where OBJECT_NAME(parent_obj)='YourTableName'

and xtype='F'

)

) as t2

where t1.temp=t2.temp

三、Access

1、所有表清单

conn.Open();

dt= conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });

2、表结构

conn.Open();

dtColumnsInfo = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new object[] { null, null, strTableName,null });

作者 nj_apple_tree