--取得sql server 的数据库名
select * from master.dbo.sysdatabases
--取得sql server 的数据表ShopWeb的用户表和视图
select * from ShopWeb.dbo.sysobjects where xtype = 'U' or Xtype ='V'
--取得sql server 的数据表ShopWeb的数据库字段
select * from shopweb.dbo.syscolumns
--取得sql server 的数据表ShopWeb的数据库字段的数据类型
select * from shopweb.dbo.SysTypes
--取得sql server 的数据表ShopWeb的用户表或视图,字段,类型,长度,备注
SELECT ShopWeb.dbo.SysObjects.Name as TableName,
ShopWeb.dbo.SysColumns.Name as ColumnsName,
ShopWeb.dbo.SysTypes.Name as DateType,
ShopWeb.dbo.SysColumns.Length as DateLength--,
ShopWeb.dbo.SysProperties.Value as Remark --列描述
FROM ShopWeb.dbo.SysObjects,
ShopWeb.dbo.SysTypes,
ShopWeb.dbo.SysColumns
LEFT JOIN ShopWeb.dbo.SysProperties
ON (ShopWeb.dbo.Syscolumns.Id = ShopWeb.dbo.Sysproperties.Id AND ShopWeb.dbo.Syscolumns.Colid = ShopWeb.dbo.Sysproperties.Smallid)
WHERE (ShopWeb.dbo.Sysobjects.Xtype ='U' OR ShopWeb.dbo.Sysobjects.Xtype ='V')
AND ShopWeb.dbo.Sysobjects.Id = ShopWeb.dbo.Syscolumns.Id
AND ShopWeb.dbo.SysTypes.XType = ShopWeb.dbo.Syscolumns.XType
AND ShopWeb.dbo.SysTypes.Name <> 'sysname'
AND ShopWeb.dbo.SysObjects.name = 'T_USER'