SQL中查询数据表字段名称的查询语句
2007-11-11 12:35:53 来源:WEB开发网以下为在sql server(WINDOWS平台上强大的数据库平台)中查看某个表的字段信息的查询语句(以数据库Pubs的jobs表为例)
SELECT SysObjects.Name as TableName,
SysColumns.Name as ColumnsName,
SysTypes.Name as DateType,
SysColumns.Length as DateLength,
SysProperties.Value as Remark --列描述
FROM SysObjects,
SysTypes,
SysColumns
LEFT JOIN SysProperties
ON (Syscolumns.Id = Sysproperties.Id AND Syscolumns.Colid = Sysproperties.Smallid)
WHERE (Sysobjects.Xtype ='u' OR Sysobjects.Xtype ='v')
AND Sysobjects.Id = Syscolumns.Id
AND SysTypes.XType = Syscolumns.XType
AND SysTypes.Name <> 'sysname'
AND SysObjects.name = 'jobs'
如果需要查询整个数据库的所有表的话,就把最后哪个条件去掉即可。
更多精彩
赞助商链接