• 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.