实用SQL: 查看表字段信息

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

本文地址：http://com.8s8s.com/it/it20729.htm