Sybase SQL查询字段类型

Sybase ASE

 

根据表名，查询表中所有字段的详细信息。包括字段名,类型,长度,是否为空,默认值,是否主键信息。
我写了一个

select     
 a.name as 字段名, 
 b.name as 字段类型,  
 a.length as 长度, 
 (case  when  a.status =8  then 'null'  else 'not mull'  end) as  是否为空, 
 isnull(e.text,'')  as 默认值 
FROM     syscolumns     a   left   join   systypes   b      
  on     a.usertype=b.usertype    
inner   join   sysobjects   d      
  on   a.id=d.id     and     d.type='U'   and     d.name<>'dtproperties'   
left   join   syscomments   e    
  on   a.cdefault=e.id    
where d.name='表名' 

 

 

 

字段名,字段类型,长度,是否为空,默认值
'usrname','varchar',64,'null',' '
'nasip','varchar',16,'null',' '