select *
from sysobjects
where xtype='u'
获得用户表的表名
select x.*
from syscolumns x ,sysobjects y
where x.id=y.id
获得字段的名字
from sysobjects
where xtype='u'
获得用户表的表名
select x.*
from syscolumns x ,sysobjects y
where x.id=y.id
获得字段的名字
2、select x.* from syscolumns x ,sysobjects y
where x.id=y.id and y.name='yourTableName'