SQL 语句查询表字段信息,及字段备注
SELECT a.NAME as tableName, b.NAME as columnName, type_name(b.xtype) as columnType,
b.length as columnLength, c.value as extendProperty
FROM sysobjects AS a
LEFT JOIN syscolumns AS b
ON a.id =b.id
LEFT JOIN sys.extended_properties AS c
ON b.id = c.m
原创
2010-10-20 10:35:00 ·
1265 阅读 ·
0 评论