Question

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

select

a.name as colname,

b.name as typename

from

syscolumns a,systypes b

where

a.xusertype=b.xusertype

and

a.id=object_id('表名')

里面填表名就可以得到字段名,字段类型.但是现在我需要的是获得某个数据库里面的表的字段名,字段类型,字段长度,不能用use 数据库这种方法

Answer 1

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

Answer 2

desc 表名