查询指定表名的列类型及长度

SELECT sysobjects.name AS 表名, syscolumns.name AS 列名,   
systypes.name AS 数据类型, syscolumns.length AS 数据长度  
FROM  
sysobjects INNER JOIN  
syscolumns ON sysobjects.id = syscolumns.id INNER JOIN  
systypes ON syscolumns.xtype = systypes.xtype  
WHERE (sysobjects.xtype = 'u' OR  
sysobjects.xtype = 'v') AND (systypes.name <> 'sysname')  
--and CONVERT(char,sysproperties.[value]) <> 'null' --导出注释不为'null'的记录  
AND (sysobjects.name = 'test') --逐个关联表名，可以用or连接条件  
ORDER BY 表名