取得数据库表信息的Sql语句代码,MSSQL代码库,德仔网

代码语言
代码分类
【MSSQL】取得数据库表信息的Sql语句
作者:Dezai.CN / 发布于2011/8/1/ 775
<div>
<div><span style="color: rgb(0,0,0)">Sql2000:

</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> d.name N</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">表名</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,a.colorder</span><span style="color: rgb(128,128,128)">-</span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(0,0,0)"> N</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">字段序号</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,a.name N</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">字段名</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,
(</span><span style="color: rgb(255,0,255)">case</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">when</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,255)">COLUMNPROPERTY</span><span style="color: rgb(0,0,0)">( a.id,a.name,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">IsIdentity</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">)</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">then</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">Y</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,255)">else</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">''</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">end</span><span style="color: rgb(0,0,0)">) N</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">标识</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,
(</span><span style="color: rgb(255,0,255)">case</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">when</span><span style="color: rgb(0,0,0)"> (</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,255)">count</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(0,0,0)">) 
</span><span style="color: rgb(0,0,255)">FROM</span><span style="color: rgb(0,0,0)"> sysobjects
</span><span style="color: rgb(0,0,255)">WHERE</span><span style="color: rgb(0,0,0)"> (name </span><span style="color: rgb(128,128,128)">in</span><span style="color: rgb(0,0,0)">
(</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> name
</span><span style="color: rgb(0,0,255)">FROM</span><span style="color: rgb(0,0,0)"> sysindexes
</span><span style="color: rgb(0,0,255)">WHERE</span><span style="color: rgb(0,0,0)"> (id </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> a.id) </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> (indid </span><span style="color: rgb(128,128,128)">in</span><span style="color: rgb(0,0,0)">
(</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> indid
</span><span style="color: rgb(0,0,255)">FROM</span><span style="color: rgb(0,0,0)"> sysindexkeys
</span><span style="color: rgb(0,0,255)">WHERE</span><span style="color: rgb(0,0,0)"> (id </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> a.id) </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> (colid </span><span style="color: rgb(128,128,128)">in</span><span style="color: rgb(0,0,0)">
(</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> colid
</span><span style="color: rgb(0,0,255)">FROM</span><span style="color: rgb(0,0,0)"> syscolumns
</span><span style="color: rgb(0,0,255)">WHERE</span><span style="color: rgb(0,0,0)"> (id </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> a.id) </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> (name </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> a.name))))))) </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)">
(xtype </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">PK</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">))</span><span style="color: rgb(128,128,128)">></span><span style="color: rgb(128,0,0); font-weight: bold">0</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">then</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">Y</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">else</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">''</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">end</span><span style="color: rgb(0,0,0)">) N</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">主键</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,
b.name N</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">类型</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,
a.length N</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">占用字节数</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,
</span><span style="color: rgb(255,0,255)">COLUMNPROPERTY</span><span style="color: rgb(0,0,0)">(a.id,a.name,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">PRECISION</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(0,0,255)">as</span><span style="color: rgb(0,0,0)"> N</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">长度</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,
</span><span style="color: rgb(255,0,255)">isnull</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(255,0,255)">COLUMNPROPERTY</span><span style="color: rgb(0,0,0)">(a.id,a.name,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">Scale</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">),</span><span style="color: rgb(128,0,0); font-weight: bold">0</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(0,0,255)">as</span><span style="color: rgb(0,0,0)"> N</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">小数位数</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,
(</span><span style="color: rgb(255,0,255)">case</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">when</span><span style="color: rgb(0,0,0)"> a.isnullable</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">then</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">Y</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,255)">else</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">''</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">end</span><span style="color: rgb(0,0,0)">) N</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">允许空</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,
</span><span style="color: rgb(255,0,255)">isnull</span><span style="color: rgb(0,0,0)">(e.</span><span style="color: rgb(0,0,255)">text</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(255,0,0)">''</span><span style="color: rgb(0,0,0)">) N</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">默认值</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,
</span><span style="color: rgb(255,0,255)">convert</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,0,255)">varchar</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,0,0); font-weight: bold">50</span><span style="color: rgb(0,0,0)">), </span><span style="color: rgb(255,0,255)">isnull</span><span style="color: rgb(0,0,0)">(g.</span><span style="color: rgb(255,0,0)">[</span><span style="color: rgb(255,0,0)">value</span><span style="color: rgb(255,0,0)">]</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(255,0,0)">''</span><span style="color: rgb(0,0,0)">)) </span><span style="color: rgb(0,0,255)">AS</span><span style="color: rgb(0,0,0)"> N</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">字段说明</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">

</span><span style="color: rgb(0,0,255)">FROM</span><span style="color: rgb(0,0,0)"> syscolumns a </span><span style="color: rgb(128,128,128)">left</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">join</span><span style="color: rgb(0,0,0)"> systypes b 
</span><span style="color: rgb(0,0,255)">on</span><span style="color: rgb(0,0,0)"> a.xtype</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)">b.xusertype
</span><span style="color: rgb(0,0,255)">inner</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">join</span><span style="color: rgb(0,0,0)"> sysobjects d 
</span><span style="color: rgb(0,0,255)">on</span><span style="color: rgb(0,0,0)"> a.id</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)">d.id </span><span style="color: rgb(128,128,128)">and</span><span style="color: rgb(0,0,0)"> d.xtype</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">U</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">and</span><span style="color: rgb(0,0,0)"> d.name</span><span style="color: rgb(128,128,128)"><></span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">dtproperties</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(128,128,128)">left</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">join</span><span style="color: rgb(0,0,0)"> syscomments e
</span><span style="color: rgb(0,0,255)">on</span><span style="color: rgb(0,0,0)"> a.cdefault</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)">e.id
</span><span style="color: rgb(128,128,128)">left</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">join</span><span style="color: rgb(0,0,0)"> sysproperties g
</span><span style="color: rgb(0,0,255)">on</span><span style="color: rgb(0,0,0)"> a.id</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)">g.id </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> a.colid </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> g.smallid 
</span><span style="color: rgb(0,0,255)">order</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">by</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,255)">object_name</span><span style="color: rgb(0,0,0)">(a.id),a.colorder



SQL2005:

</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> d.name N</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">表名</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,a.colorder</span><span style="color: rgb(128,128,128)">-</span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(0,0,0)"> N</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">字段序号</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,a.name N</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">字段名</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,
(</span><span style="color: rgb(255,0,255)">case</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">when</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,255)">COLUMNPROPERTY</span><span style="color: rgb(0,0,0)">( a.id,a.name,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">IsIdentity</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">)</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">then</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">Y</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,255)">else</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">''</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">end</span><span style="color: rgb(0,0,0)">) N</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">标识</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,
(</span><span style="color: rgb(255,0,255)">case</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">when</span><span style="color: rgb(0,0,0)"> (</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,255)">count</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(0,0,0)">) 
</span><span style="color: rgb(0,0,255)">FROM</span><span style="color: rgb(0,0,0)"> sysobjects
</span><span style="color: rgb(0,0,255)">WHERE</span><span style="color: rgb(0,0,0)"> (name </span><span style="color: rgb(128,128,128)">in</span><span style="color: rgb(0,0,0)">
(</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> name
</span><span style="color: rgb(0,0,255)">FROM</span><span style="color: rgb(0,0,0)"> sysindexes
</span><span style="color: rgb(0,0,255)">WHERE</span><span style="color: rgb(0,0,0)"> (id </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> a.id) </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> (indid </span><span style="color: rgb(128,128,128)">in</span><span style="color: rgb(0,0,0)">
(</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> indid
</span><span style="color: rgb(0,0,255)">FROM</span><span style="color: rgb(0,0,0)"> sysindexkeys
</span><span style="color: rgb(0,0,255)">WHERE</span><span style="color: rgb(0,0,0)"> (id </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> a.id) </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> (colid </span><span style="color: rgb(128,128,128)">in</span><span style="color: rgb(0,0,0)">
(</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> colid
</span><span style="color: rgb(0,0,255)">FROM</span><span style="color: rgb(0,0,0)"> syscolumns
</span><span style="color: rgb(0,0,255)">WHERE</span><span style="color: rgb(0,0,0)"> (id </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> a.id) </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> (name </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> a.name))))))) </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)">
(xtype </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">PK</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">))</span><span style="color: rgb(128,128,128)">></span><span style="color: rgb(128,0,0); font-weight: bold">0</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">then</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">Y</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">else</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">''</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">end</span><span style="color: rgb(0,0,0)">) N</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">主键</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,
b.name N</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">类型</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,
a.length N</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">占用字节数</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,
</span><span style="color: rgb(255,0,255)">COLUMNPROPERTY</span><span style="color: rgb(0,0,0)">(a.id,a.name,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">PRECISION</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(0,0,255)">as</span><span style="color: rgb(0,0,0)"> N</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">长度</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,
</span><span style="color: rgb(255,0,255)">isnull</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(255,0,255)">COLUMNPROPERTY</span><span style="color: rgb(0,0,0)">(a.id,a.name,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">Scale</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">),</span><span style="color: rgb(128,0,0); font-weight: bold">0</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(0,0,255)">as</span><span style="color: rgb(0,0,0)"> N</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">小数位数</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,
(</span><span style="color: rgb(255,0,255)">case</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">when</span><span style="color: rgb(0,0,0)"> a.isnullable</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">then</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">Y</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,255)">else</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">''</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">end</span><span style="color: rgb(0,0,0)">) N</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">允许空</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,
</span><span style="color: rgb(255,0,255)">isnull</span><span style="color: rgb(0,0,0)">(e.</span><span style="color: rgb(0,0,255)">text</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(255,0,0)">''</span><span style="color: rgb(0,0,0)">) N</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">默认值</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,
</span><span style="color: rgb(255,0,255)">convert</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,0,255)">varchar</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,0,0); font-weight: bold">50</span><span style="color: rgb(0,0,0)">), </span><span style="color: rgb(255,0,255)">isnull</span><span style="color: rgb(0,0,0)">(g.</span><span style="color: rgb(255,0,0)">[</span><span style="color: rgb(255,0,0)">value</span><span style="color: rgb(255,0,0)">]</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(255,0,0)">''</span><span style="color: rgb(0,0,0)">)) </span><span style="color: rgb(0,0,255)">AS</span><span style="color: rgb(0,0,0)"> N</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">字段说明</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">

</span><span style="color: rgb(0,0,255)">FROM</span><span style="color: rgb(0,0,0)"> syscolumns a </span><span style="color: rgb(128,128,128)">left</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">join</span><span style="color: rgb(0,0,0)"> systypes b 
</span><span style="color: rgb(0,0,255)">on</span><span style="color: rgb(0,0,0)"> a.xtype</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)">b.xusertype
</span><span style="color: rgb(0,0,255)">inner</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">join</span><span style="color: rgb(0,0,0)"> sysobjects d 
</span><span style="color: rgb(0,0,255)">on</span><span style="color: rgb(0,0,0)"> a.id</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)">d.id </span><span style="color: rgb(128,128,128)">and</span><span style="color: rgb(0,0,0)"> d.xtype</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">U</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">and</span><span style="color: rgb(0,0,0)"> d.name</span><span style="color: rgb(128,128,128)"><></span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">dtproperties</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(128,128,128)">left</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">join</span><span style="color: rgb(0,0,0)"> syscomments e
</span><span style="color: rgb(0,0,255)">on</span><span style="color: rgb(0,0,0)"> a.cdefault</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)">e.id
</span><span style="color: rgb(128,128,128)">left</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">join</span><span style="color: rgb(0,0,0)"> sys.extended_properties g
</span><span style="color: rgb(0,0,255)">on</span><span style="color: rgb(0,0,0)"> a.id</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)">g.major_id </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> a.colid </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> g.minor_id 
</span><span style="color: rgb(0,0,255)">order</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">by</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,255)">object_name</span><span style="color: rgb(0,0,0)">(a.id),a.colorder</span></div>
</div>
试试其它关键字
　据库表信息　
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)