-- Tables descriptions: SELECT sysobjects.name as cTable, sysproperties.value as cDescription FROM sysobjects JOIN sysproperties ON sysobjects.id = sysproperties.id WHERE sysproperties.smallid = 0 ORDER BY 1 -- Fields descriptions: SELECT sysobjects.name as cTable, syscolumns.name as cColumn, systypes.name as cType, syscolumns.Length as nLength, syscolumns.xprec as nPrecision, syscolumns.xscale as nScale, sysproperties.value as cDescription FROM syscolumns JOIN sysproperties ON syscolumns.id = sysproperties.id AND syscolumns.colid = sysproperties.smallid JOIN sysobjects ON syscolumns.id = sysobjects.id JOIN systypes ON syscolumns.xtype = systypes.xtype ORDER BY 1It works for any SQL Server 2000 database.