The sysnewdepend system catalog table contains information about generalized-key indexes that are not available in the sysindexes table. The dependencies between a generalized-key index and the tables in the FROM clause of the CREATE INDEX statement are stored in the sysnewdepend table, which has the following columns.
| Column | Type | Explanation | |
|---|---|---|---|
| scrid1 | VARCHAR(128) | Name of the generalized-key index | |
| scrid2 | INTEGER | Unique identifying code ( = tabid) of the indexed table | |
| type | INTEGER | Code for the type of generalized-key index | |
| destid1 | INTEGER | The systables.tabid value for the table on which the generalized-key index depends | |
| destid2 | INTEGER | The column number within the destid1 table | |
A composite index on the scrid1, scrid2, and type columns allows duplicate values. Another composite index on the destid1, destid2, and type columns also allows duplicate values.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]