Primary, foreign, and common keys for the system tables are defined in the master and model databases. You can generate 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.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
