SQL Server 根据表名查询包含的列名、类型、长度等
select c.name as '列名', case when c.is_identity = 1 then '√' else '×' end as '自增', ty.name as '数据类型', c.max_length as '长度', case when c.is_nullable=1 then '√' else '×' end as '允许null', isnull(e.value,'') as '说名' from sys.tables as t join sys.all_columns as c on t.object_id=c.object_id left join sys.extended_properties as e on e.major_id=c.object_id and e.minor_id=c.column_id join sys.types as ty on ty.user_type_id=c.user_type_id where t.name='calss' and SCHEMA_NAME(t.schema_id)='school'