实用SQL: 查看表字段信息

发表于:2007-05-25来源:作者:点击数: 标签:sql看表Select字段实用
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://www.ltesting.net