MsSQL SQLServer 查询 表中字段的及类型是否为空

SELECT   name AS column_name,TYPE_NAME(system_type_id) AS column_type,  max_length,is_nullable FROM sys.columns WHERE object_id=OBJECT_ID(N'表名')