在sql server 中，如何获取SQL字段默认值呢？下面就为您介绍实现该功能的方法，如果您遇到过类似的问题，不妨一看，希望对您有所帮助。
sql server 中获取SQL字段默认值 ，获取所有的默认值列表：
- select
- object_name(c.id) as 表名
- ,c.name as 字段名
- ,t.name as 数据类型
- ,c.prec as 长度
- ,p.value as 字段说明
- ,m.text as 默认值
- from syscolumns c
- inner join
- systypes t
- on c.xusertype=t.xusertype
- left join
- sysproperties p
- on c.id=p.id and c.colid = p.smallid
- left join
- syscomments m
- on c.cdefault=m.id
研究了很久 终于搞定了
获取单个SQL字段默认值列表
- select
- object_name(c.id) as 表名
- ,c.name as 字段名
- ,t.name as 数据类型
- ,c.prec as 长度
- ,p.value as 字段说明
- ,m.text as 默认值
- from syscolumns c
- inner join
- systypes t
- on c.xusertype=t.xusertype
- left join
- sysproperties p
- on c.id=p.id and c.colid = p.smallid
- left join
- syscomments m
- on c.cdefault=m.id
- where objectproperty(c.id,'IsUserTable')=1
- and object_name(c.id) = 'T_good' and c.name = 'ishot'
【编辑推荐】
