以下为在SQL Server中查看某个表的字段信息的查询语句（以数据库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'
如果需要查询整个数据库的所有表的话，就把最后哪个条件去掉即可。