MSSQL 获取表对应的列明，备注，字段类型

���系统代码CV多了想解放一下双手写个代码生成器，这时候就需要获取到表的某一些信息了

SELECT  a.NAME AS colname, CONCAT(UPPER(SUBSTRING(b.name, 1, 1)), LOWER(SUBSTRING(b.name, 2,LEN(b.name)-1))) AS typename, a.length AS length, a.scale AS scale, a.prec AS prec, c.name,isnull(f.[value],'') as remarkFROM syscolumns ainner join systypes b on a.xusertype = b.xusertypeinner join sysobjects c on a.id = c.id inner join sys.columns d on d.name=a.nameinner joinsys.objects e on d.object_id=e.object_id and e.Type='U'left joinsys.extended_properties f on f.major_id=e.object_id and f.minor_id=d.Column_id and f.class=1where  c.name = 'tableName' and e.name='tableName'order by a.colorder asc