查询表字段、类型、是否主键代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】查询表字段、类型、是否主键

作者:Dezai.CN / 发布于2012/12/4/ 654

select SO.name as TableName,SC.name as TableCloumn,ST.name as DataType,
(
SELECT COUNT(1) AS Is_PK 
 FROM  syscolumns  
 JOIN  sysindexkeys  ON   syscolumns.id=sysindexkeys.id  AND  syscolumns.colid=sysindexkeys.colid   
 JOIN  sysindexes   ON   syscolumns.id=sysindexes.id  AND  sysindexkeys.indid=sysindexes.indid  
 JOIN  sysobjects   ON   sysindexes.name=sysobjects.name  AND  sysobjects.xtype='PK'
 WHERE syscolumns.name=SC.name AND syscolumns.id=object_id(SO.name)
) as IsPrimaryKey
,SC.colid as CloumnIndex 
from sysobjects SO 
inner join syscolumns SC on SO.id = SC.id  and  SO.xtype = 'U' and  SO.status >= 0 and SO.name= '这里是数据库的表名'
inner join systypes ST on SC.xtype = ST.xusertype 
order by SO.name asc, SC.colorder asc

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

　查询表字段　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)