当前位置: 数据库>sqlserver
sql代码：select database select all table
来源: 互联网 发布时间：2014-08-29
本文导语: sql代码：select database select all table，供大家学习参考。 代码如下: ---表中的主鍵 select [name],'tablekey'= (select top 1 COLUMN_NAME from INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = sysobjects.name) from sysobjects where type='U' -...
sql代码：select database select all table，供大家学习参考。
代码如下:
---表中的主鍵
select [name],'tablekey'= (select top 1 COLUMN_NAME from INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = sysobjects.name) from sysobjects where type='U'
--所有表
select * from sysobjects where type='U'
--所有表的主鍵 COLUMN_NAME
select * from INFORMATION_SCHEMA.KEY_COLUMN_USAGE
--数据类型
select * from systypes
--所有列
select * FROM syscolumns
--所有表的數據類型，長度
SELECT d.name TableName,a.name FieldName,b.name TypeName,a.length Length,a.isnullable IS_NULL --INTO #t
FROM syscolumns a, systypes b,sysobjects d
WHERE a.xtype=b.xusertype and a.id=d.id and d.xtype='U'
---所有表的主鍵
SELECT d.name as 'TableName',a.name as 'FieldName',b.name as 'TypeName',a.length as 'Length',a.isnullable as 'IS_NULL' --INTO #t
FROM syscolumns a, systypes b,sysobjects d ,INFORMATION_SCHEMA.KEY_COLUMN_USAGE c
WHERE a.xtype=b.xusertype and a.id=d.id and d.xtype='U' and c.TABLE_NAME = d.name
and c.COLUMN_NAME=a.name
select [name],'tablekey'= (select top 1 COLUMN_NAME from INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = sysobjects.name) from sysobjects where type='U'
--所有表
select * from sysobjects where type='U'
--所有表的主鍵 COLUMN_NAME
select * from INFORMATION_SCHEMA.KEY_COLUMN_USAGE
--数据类型
select * from systypes
--所有列
select * FROM syscolumns
--所有表的數據類型，長度
SELECT d.name TableName,a.name FieldName,b.name TypeName,a.length Length,a.isnullable IS_NULL --INTO #t
FROM syscolumns a, systypes b,sysobjects d
WHERE a.xtype=b.xusertype and a.id=d.id and d.xtype='U'
---所有表的主鍵
SELECT d.name as 'TableName',a.name as 'FieldName',b.name as 'TypeName',a.length as 'Length',a.isnullable as 'IS_NULL' --INTO #t
FROM syscolumns a, systypes b,sysobjects d ,INFORMATION_SCHEMA.KEY_COLUMN_USAGE c
WHERE a.xtype=b.xusertype and a.id=d.id and d.xtype='U' and c.TABLE_NAME = d.name
and c.COLUMN_NAME=a.name
您可能感兴趣的文章:
本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术，将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外，均为转载、整理或搜集自网络。欢迎任何形式的转载，转载请注明出处。
本站(WWW.)站内文章除注明原创外，均为转载、整理或搜集自网络。欢迎任何形式的转载，转载请注明出处。