MsSql 生成数据文档

Declare @tableName varchar(50)

Set  @tableName = '表名'

select syscolumns.name as 字段名, syscolumns.length as 长度, systypes.name   as   '数据类型', sys.extended_properties.[value] AS '字段说明',syscolumns.isnullable as '是否允许空值'  from   syscolumns join systypes   on     syscolumns.xtype=systypes.xtype   and   systypes.name <> 'sysname' LEFT OUTER JOIN sys.extended_properties ON ( sys.extended_properties.minor_id = syscolumns.colid AND sys.extended_properties.major_id = syscolumns.id) where   syscolumns.id   in (select   id   from   sysobjects   where   name= @tableName)