谢谢
---------------------------------------------------------------
sysobject表中都有
---------------------------------------------------------------
select * from sysobjects
---------------------------------------------------------------
sysobjects是系统表，从此表中可以查询处你建立的表的信息：）
参考：
select t1.tablename,t1.colname,descr=isnull(t2.value,''),t1.type,t1.length,t1.isnullable from
(select a.id,tablename=d.name,colname=a.name ,colid=a.colid,type=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' )t1 left join sysproperties t2 on t1.id=t2.id and t1.colid=t2.smallid