随笔分类 - 数据库 - DataBase
查询数据库表字段的说明
摘要:--查询语句SELECT [Table Name] = OBJECT_NAME(col.object_id), [Column Name] = col.name, [Description] = ex.value FROM sys.columns col LEFT OUTER JOIN sys.extended_properties ex ON ex.major_id = col.object_id AND ex.minor_id = col.column_id AND ex.name = 'MS_Description' WHERE OBJECTPROPERTY(col.o.
阅读全文
浙公网安备 33010602011771号