select d.name,a.name ,b.name ,a.length, a.isnullable from syscolumns a, systypes b,sysobjects d where a.xtype=b.xusertype and a.id=d.id and d.xtype='U'
CREATE PROCEDURE OZY_TableInfo @TableName as varchar(30) ASselect a.name as '字段',b.name as '类型',a.length as '长度' from sysobjects as c left join syscolumns as a on c.id = a.id left join systypes b on a.xtype = b.xtype where c.name = @TableNameGO
select d.name,a.name ,b.name ,a.length, a.isnullable from syscolumns a, systypes b,sysobjects d where a.xtype=b.xusertype and a.id=d.id and d.xtype='U' and d.status>0
@TableName as varchar(30)
ASselect a.name as '字段',b.name as '类型',a.length as '长度'
from sysobjects as c
left join syscolumns as a on c.id = a.id
left join systypes b on a.xtype = b.xtype
where c.name = @TableNameGO
from syscolumns a, systypes b,sysobjects d
where a.xtype=b.xusertype and a.id=d.id and d.xtype='U' and d.status>0