首页 > 代码库 > SQL查询所有表,所有列

SQL查询所有表,所有列

1.查询实例中所有数据库

select name,database_id from sys.databases

2.查询数据库中所有表
select TABLE_TYPE,TABLE_NAME from information_schema.tables order by TABLE_NAME

select * from sysobjects where type=‘U‘ order by name(所有表)
select * from sysobjects where type=‘SQ‘ order by name
select * from sysobjects where type=‘FN‘ order by name
select * from sysobjects where type=‘S‘ order by name
select * from sysobjects where type=‘D‘ order by name
select * from sysobjects where type=‘IT‘ order by name
select * from sysobjects where type=‘F‘ order by name
select * from sysobjects where type=‘F‘ order by name
select * from sysobjects where type=‘PK‘ order by name(所有主键)
select * from sysobjects where type=‘P‘ order by name
select * from sysobjects where type=‘TF‘ order by name
select * from sysobjects where type=‘C‘ order by name
select * from sysobjects where type=‘UQ‘ order by name
select * from sysobjects where type=‘V‘ order by name(所有视图)

SQL查询所有表,所有列