获取表中列的详细信息

create proc GetListsColumnInfoByTableName(@tablename varchar(10))
as 
begin
SELECT z.name as 列名,
(case when z.is_identity = 1 then 'PK' else '' end) as 主键,
x.name as 类型,
max_length as 长度, 
(case when z.is_nullable = 0 then 'N' else 'Y' end) as 可空
from sys.systypes x inner join sys.all_columns z 
on x.xusertype = z.user_type_id 
and z.object_id = (select object_id from sys.all_objects where name = 'Customer')
end

exec GetListsColumnInfoByTableName 'Customer'