以下是引用有点甜在2014-4-30 9:28:00的发言: 再弄一下,就是这样 select a.name, b.name, a.length from syscolumns a inner join systypes b on a.xtype=b.xtype where id=object_id('表A')
再加以条件吧
select a.name, b.name, a.length from syscolumns a inner join systypes b on a.xtype=b.xtype where id=object_id('表A') And b.allownulls = 1