SQL Server 2000 里查询得到当前数据库的所有数据表名 select * from sysobjects where objectproperty(id,'isusertable')=1 order by name sp_tables select * from INFORMATION_SCHEMA.TABLES select * from sysobjects where objectproperty(id,'isusertable')=1 order by name select * from sysobjects where xtype='U' 以上会查出dtproperties表(作用是存储数据库的关系图) select * from sysobjects where xtype='U' and status>0 获得各个用户表之间关联关系的SQL select object_name(A.parent_obj) as 表名 ,col_name(A.parent_obj,B.fkey) as 列名 ,object_name(B.rkeyid) as 引用表名 ,col_name(B.rkeyid,B.rkey) as 引用列名 from sysobjects A join sysforeignkeys B on A.id=B.constid