Listing 1: Query for Obtaining Information About Tables

SELECT
	object_name(sysobjects.id) TableName,
	rows,
	dpages
FROM
	sysindexes,
	sysobjects
WHERE
	sysindexes.id = sysobjects.id 
	and sysobjects.type = "U"
	and sysindexes.indid in (0,1)
ORDER BY
	rows desc