获取指定表的字段信息sql2005
摘要:
select syscolumns.name as ColName ,systypes.name as ColTypeName , syscolumns.length, sys.extended_properties.value as Mark ,syscolumns.isnullable as AllowNull ,IsPK = Case when exists ( select 1 from sysobjects inner join sysin... 阅读全文
posted @ 2011-12-24 14:41 遗忘海岸 阅读(184) 评论(0) 推荐(0) 编辑