sql查找表中列的属性


select a.name columnname,c.name as typename,
case when a.is_nullable = 0 then 'Not Null' else 'Null' end as nullable,
a.*from sys.columns a ,
sys.objects b,
sys.types c
where a.object_id = b.object_id
and b.name='Product'and
a.system_type_id=c.system_type_id order by a.column_id