Hello,

I have the following query:

select c.name,t.name,c.length, cc.text as [default]
from systypes t,sysobjects o, syscolumns c ,syscomments cc
where 1=1
and c.id=o.id
and t.xtype=c.xtype
and c.cdefault*=cc.id
and o.name='tblcustomers'
and t.name<>'sysname'
order by c.colorder

It gives me column name, type, size, default value - how do I find out if the field allows nulls?

Thanks in advance!