All Table Space in a database

Select a.name "TABLE_NAME", b.rowcnt "ROWS",b.used*8/1024 "SPACE USED(MB)", b.reserved*8/1024 "ALLOCATED SPACE(MB)",a.crdate "DOB"
from sysobjects a, sysindexes b where a.xtype='U' and b.indid in (0,1) and a.id=b.id