sql server2005过系统表查出数据表的字段名称字段类型和字段长度

select
syscolumns.name as 'ColumnsName',
SysTypes.name as 'DataType',
SysColumns.Length as 'DataLength'
from
syscolumns
inner join sysobjects on syscolumns.id=sysobjects.id
inner join SysTypes on Syscolumns.XType=SysTypes.XType
where
SysTypes.Name!='sysname' and
sysobjects.name='VM_ShipOilList' -- 在这里把表名换掉
order by syscolumns.id