Declare@tblNamenvarchar(1000) set@tblName='表名' declare@TblIDint set@TblID=(select[object_id]as tblID from sys.all_objects where[type]='U'and[name]<>'dtproperties'and[name]=@tblName) select syscolumns.name as ColumnName, systypes.name as ColumnType, syscolumns.length as ColumnLength, (SELECT[value]FROM ::fn_listextendedproperty(NULL, 'user', 'dbo', 'table', object_name(@TblID), 'column', syscolumns.name) as e where e.name='MS_Description') as ColumnDescription from sysColumns leftjoin sysTypes on sysTypes.xtype = sysColumns.xtype and sysTypes.xusertype = sysColumns.xusertype leftjoin sysobjects on sysobjects.id = syscolumns.cdefault and sysobjects.type='D' leftjoin syscomments on syscomments.id = sysobjects.id where syscolumns.id=@TblID