【sqlserver】【View】表列信息vtabinfo

create view vtabinfo as
select * from(
SELECT t.name           TabName,--表名
       s.name           SchName, --Schema名
       c.name           ColName,--列名
         c.name+','  ColNameOut,
       tp.name          DataType,
       c.is_nullable isnullable,
       c.is_identity, --是否自增
       c.max_length,
       c.collation_name,
       (select sc.colid from syscolumns sc where sc.id=c.object_id and c.name=sc.name) colid--列顺序
  FROM sys.tables t, sys.columns c, sys.schemas s, sys.types tp
 WHERE t.schema_id = s.schema_id
   and t.object_id = c.object_id
   and c.system_type_id = tp.system_type_id
   and tp.name<>'sysname' --系统中nvarchar等价于sysname类型
   ) t