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'