查看表字段信息

查看表字段信息 无 select c.colid, c.name, c.xtype, c.length, xprecfrom syscolumns cinner join sysobjects o on o.id=c.idwhere o.name='INVMA'order by colid

查看表字段信息

select c.colid, c.name, c.xtype, c.length, xprec
from syscolumns c
inner join sysobjects o on o.id=c.id
where o.name='INVMA'
order by colid