SQL Server2008中通过SQL获取表结构

概述SQL Server2008中通过SQL获取表结构

下面是内存溢出 jb51.cc 通过网络收集整理的代码片段。

内存溢出小编现在分享给大家，也给大家做个参考。

select   syscolumns.name as [name],systypes.name as [Type],syscolumns.length AS [Size],syscolumns.xprec As [Precision],ISNulL(syscolumns.scale,0) AS [Scale],sys.extended_propertIEs.value as [Mark],syscolumns.isnullable as [NulL],(Case when exists(  select 1 from sysobjects   inner join sysindexes on sysindexes.name = sysobjects.name     inner join sysindexkeys on sysindexes.ID = sysindexkeys.ID and  sysindexes.indID = sysindexkeys.indID    where xtype='PK' and parent_obj = syscolumns.ID       and sysindexkeys.colID = syscolumns.colID) then 1 else 0 end) AS [PK],(Case syscolumns.status when 128 then 1 else 0 end) AS [IDentity]   from syscolumns     inner join systypes on (    syscolumns.xtype = systypes.xtype     and systypes.name <>'_default_'      and systypes.name<>'sysname')     left outer join sys.extended_propertIEs on (    sys.extended_propertIEs.major_ID=syscolumns.ID      and minor_ID=syscolumns.colID)     where syscolumns.ID = (select ID from sysobjects where name='NDS_TfileForm')    order by syscolumns.colID  

以上是内存溢出(jb51.cc)为你收集整理的全部代码内容，希望文章能够帮你解决所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。

总结

以上是内存溢出为你收集整理的SQL Server2008中通过SQL获取表结构全部内容，希望文章能够帮你解决SQL Server2008中通过SQL获取表结构所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。