sybase 查看表结构语句

xiawared

select a.colid as id,b.name as tab_name,a.name as col_name,c.name as type,a.length as all_length,a.prec as length,a.scale,case isnull(a.status,0) when 0 then 'NOT NULL' ELSE 'NULL' END AS isnull
from syscolumns a,sysobjects b,systypes c
where a.id=b.id and a.usertype=c.usertype and b.name = @tablename