mssql显示表结构

SELECT syscolumns.name,systypes.name,syscolumns.isnullable,syscolumns.length 
FROM syscolumns, systypes 
WHERE syscolumns.xusertype = systypes.xusertype AND syscolumns.id = object_id('表名')

 

 

例如：

SELECT syscolumns.name as '字段',systypes.name+'('+convert(varchar(20),syscolumns.length)+')' as '类型' ,'备注'=''
FROM syscolumns, systypes 
WHERE syscolumns.xusertype = systypes.xusertype AND syscolumns.id = object_id('xxxx')