While the information you are getting is invaluable --why make systables your first stop? Information_schema views are much more user-friendly. (Table_name vs object_name(id)). And they upgrade better.
Only bugger with Information_Schema views -- Indexes are unavailable and you must resort to a function or sysindexes.