2012年8月31日

sqlserver 2008获取列备注信息

摘要： SELECT A.name As 表明,B.Name As 列名, B.xtype As 列类型,C.Value As 字段说明 FROM sysobjects As A INNER JOIN syscolumns As B ON A.id = B.id INNER JOIN sys.extended_properties As C ON C.major_id = A.id AND ( minor_id = B.colid) 阅读全文

posted @ 2012-08-31 09:54 lanyue52011 阅读(207) 评论(0) 推荐(0)

sqlserver 2008 获取列备注

摘要： SELECT A.name As 表明,B.Name As 列名, B.xtype As 列类型,C.Value As 字段说明 FROM sysobjects As A INNER JOIN syscolumns As B ON A.id = B.id INNER JOIN sys.extended_properties As C ON C.major_id = A.id AND ( minor_id = B.colid) 阅读全文

posted @ 2012-08-31 09:53 lanyue52011 阅读(166) 评论(0) 推荐(0)

导航