SQL Server 2008数据库显示表结构的存储过程

2025-11-05 04:23:16分类：人工智能阅读(6)

复制SETANSI_NULLSON   GO   SETQUOTED_IDENTIFIERON   GO   --查询数据字典    CREATEproc[dbo].[help]   @tableNamevarchar(50)   as   SELECT   (casewhena.colorder=1thend.nameelseend)表名,据库   --a.colorder字段序号,    a.name字段名,   isnull(g.[value],)AS字段说明,   b.name类型,   COLUMNPROPERTY(a.id,a.name,PRECISION)as长度,   isnull(COLUMNPROPERTY(a.id,a.name,Scale),0)as小数位数,   (casewhen(SELECTcount(*)   FROMsysobjects   WHERE(namein   (SELECTname   FROMsysindexes   WHERE(id=a.id)AND(indidin   (SELECTindid   FROMsysindexkeys   WHERE(id=a.id)AND(colidin   (SELECTcolid   FROMsyscolumns   WHERE(id=a.id)AND(name=a.name)))))))AND   (xtype=PK))>0then是elseend)是服务器托管否主键,   (casewhena.isnullable=1thenelse是香港云服务器end)是免费源码下载否必填,   isnull(e.text,)默认值   FROMsyscolumnsaleftjoinsystypesb   ona.xtype=b.xusertype   innerjoinsysobjectsd   ona.id=d.idandd.xtype=Uandd.name<>dtproperties   leftjoinsyscommentse   ona.cdefault=e.id   leftjoinsys.extended_propertiesg   ona.id=g.major_idANDa.colid=g.minor_id   whered.name=@tableName   orderbyd.name,a.colorder   GO  1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.