查询SQL数据库所有表名、字段名、备注、字段类型、字段长度

SELECT sysobjects.id,sysobjects.name AS TABLE_NAME, syscolumns.name AS column_name,
systypes.name AS data_type, syscolumns.length AS CHARACTER_MAXIMUM_LENGTH, CONVERT(char,
sys.extended_properties.[value]) AS value
FROM sys.extended_properties RIGHT OUTER JOIN
sysobjects INNER JOIN
syscolumns ON sysobjects.id = syscolumns.id INNER JOIN
systypes ON syscolumns.xtype = systypes.xtype ON
sys.extended_properties.major_id = syscolumns.id AND
sys.extended_properties.minor_id = syscolumns.colid
WHERE (sysobjects.xtype = 'u' OR
sysobjects.xtype = 'v') AND (systypes.name <> 'sysname')
ORDER BY TABLE_NAME

mayb