sql如何获得某个数据库里面的表的字段名,字段类型,字段长度(sql server2005)

select * from sysobjects 查询所有表 select c.name as tablename, a.name as colname, b.name as typename from syscolumns a,systypes b ,sysobjects c where a.xusertype=b.xusertype and a.id=c.id order by c.id