日期:2014-05-18 浏览次数:20587 次
select a.name as '表名',b.name as '字段名',b.isnullable,case when b.isnullable=1 then '允许Null' else '不允许Null' end as '是否允许Null' from sysobjects as a inner join syscolumns as b on a.id=b.id and a.xtype='U' and a.name='TableName'