Primary, foreign, and common keys for the system tables are defined in the master and model databases. You can get a report on defined keys by executing sp_helpkey. For a report on columns in two system tables that are likely join candidates, execute sp_helpjoins.
The Adaptive Server System Tables Diagram included with Adaptive Server shows the relationships between columns in the system tables.
