下面为您介绍的是列出SQL SERVER 数据库所有表信息的SQL语句，该SQL语句供您参考，希望对您学习SQL语句能有所启迪。

select 
(casewhena.colorder=1thend.nameelse''end)表名, 
a.colorder字段序号, 
a.name字段名, 
(casewhenCOLUMNPROPERTY(a.id,a.name,'isidentity')=1then'√'else''end)标识 
(casewhen( 
selectcount(*)fromsysobjects 
wherenamein( 
selectnamefromsysindexes 
where(id=a.id)and(indidin 
(selectindidfromsysindexkeyswhere 
(id=a.id)and(colidin( 
selectcolidfromsyscolumns 
where(id=a.id)and(name=a.name)))))) 
and(xtype='PK'))>0then'√'else''end)主键, 
b.name类型, 
a.length字节数, 
COLUMNPROPERTY(a.id,a.name,'PRECISION')as长度, 
isnull(COLUMNPROPERTY(a.id,a.name,'Scale'),0)as小数位数, 
(casewhena.isnullable=1then'√'else''end)允许空, 
isnull(e.text,'')默认值, 
isnull(g.[value],'')as字段说明 
fromsyscolumnsaleftjoinsystypesb 
ona.xtype=b.xusertype 
innerjoinsysobjectsd 
ona.id=d.idandd.xtype='U'andd.name<>'dtproperties' 
leftjoinsyscommentse 
ona.cdefault=e.id 
leftjoinsyspropertiesg 
ona.id=g.idanda.colid=g.smallid 
orderbya.id,a.colorder 
 

【编辑推荐】

批量执行SQL语句的示例

修改SQL主键约束的SQL语句写法

教您使用SQL语句修改SQL主键

逐条更新数据的SQL语句写法

对存储过程代替SQL语句的讨论