日期:2011-01-25 23:11:00 来源:本站整理
<b>列出SQL SERVER数据库全部表信息的SQL语句</b>[MSSQL防范]
本文“<b>列出SQL SERVER数据库全部表信息的SQL语句</b>[MSSQL防范]”是由七道奇为您精心收集,来源于网络转载,文章版权归文章作者所有,本站不对其观点以及内容做任何评价,请读者自行判断,以下是其具体内容:
下面为您介绍的是列出SQL SERVER 数据库全部表信息的SQL语句,该SQL语句供您参考,但愿对您学习SQL语句能有所启迪.
<
- select
- ( case when a.colorder = 1 then d.name else '' end ) 表名,
- a.colorder 字段序号,
- a.name 字段名,
- ( case when COLUMNPROPERTY (a.id,a.name,'isidentity') = 1 then '√' else '' end ) 标识
- ( case when (
- select count(*) from sysobjects
- where name in (
- select name from sysindexes
- where (id = a.id ) and ( indid in
- (select indid from sysindexkeys where
- ( id = a.id ) and ( colid in (
- select colid from syscolumns
- where ( id = a.id ) and ( name = a.name ))))))
- and ( xtype ='PK')) > 0 then '√' else '' end ) 主键,
- b.name 范例,
- a.length 字节数,
- COLUMNPROPERTY ( a.id,a.name ,'PRECISION' ) as 长度,
- isnull ( COLUMNPROPERTY ( a.id,a.name ,'Scale'),0) as 小数位数,
- (case when a.isnullable = 1 then '√' else '' end ) 答应空,
- isnull ( e.text,'') 默许值,
- isnull (g.[value],'' ) as 字段阐明
- from syscolumns a left join systypes b
- on a.xtype = b.xusertype
- inner join sysobjects d
- on a.id = d.id and d.xtype='U' and d.name <> 'dtproperties'
- left join syscomments e
- on a.cdefault = e.id
- left join sysproperties g
- on a.id = g.id and a.colid = g.smallid
- order by a.id ,a.colorder
以上是“<b>列出SQL SERVER数据库全部表信息的SQL语句</b>[MSSQL防范]”的内容,如果你对以上该文章内容感兴趣,你可以看看七道奇为您推荐以下文章:
本文地址: | 与您的QQ/BBS好友分享! |
评论内容只代表网友观点,与本站立场无关!
评论摘要(共 0 条,得分 0 分,平均 0 分)
查看完整评论