SQL 创建字段说明并查询

create table student(id int not NULL,name varchar(10) not null)EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'student', @level2type=N'COLUMN',@level2name=N'id'GOEXEC sys.sp_updateextendedproperty @name=N'MS_Description', @value=N'姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'student', @level2type=N'COLUMN',@level2name=N'name'GOSELECT t.[name] AS 表名,c.[name] AS 字段名,cast(ep.[value]   as varchar(100)) AS [字段说明]  FROM sys.tables AS t  INNER JOIN sys.columns   AS c ON t.object_id = c.object_id   LEFT JOIN sys.extended_properties AS ep   ON ep.major_id = c.object_id AND ep.minor_id = c.column_id WHERE ep.class =1   AND t.name='student'