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)为你收集整理的全部代码内容，希望文章能够帮你解决所遇到的程序开发问题。

如果觉得脚本之家网站内容还不错，欢迎将脚本之家网站推荐给程序员好友。

（编辑：安卓应用网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!