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
sybase 查看表结构语句
最新推荐文章于 2021-07-14 15:59:10 发布