sql查询数据库中所有表名+字段名+类型等
1.查询数据库中所有表名+字段名+类型
SELECT A.name AS fField, B.name AS fType, C.name AS fTABLE
FROM dbo.syscolumns A INNER JOIN
dbo.systypes B ON A.xusertype = B.xusertype RIGHT OUTER JOIN
(SELECT *
FROM SYSOBJECTS
WHERE TYPE = ‘U’) C ON A.id = C.id
2.查询表的所有字段
select syscolumns.name from syscolumns where id=object_id(‘写上要查询的表ID’)
3.查询表的所有字段+表字段对应的类型+类型的长度
select syscolumns.name,systypes.name,systypes.name+’(’+cast(syscolumns.length/2 as varchar(10))+’)’,
syscolumns.length
from syscolumns,systypes
where syscolumns.xusertype=systypes.xusertype and syscolums.id=object_id(‘写上要查询的表ID’)
4.查询表的所有字段+表字段对应的类型
select syscolumns.name,systypes.name from syscolumns,systypes where syscolumns.xusertype=systypes.xusertype and syscolumns.id=object_id(‘写上要查询的表ID’)
5.查出所有表名
SELECT NAME FROM SYSOBJECTS WHERE TYPE=‘U’