X$Depend
The X$Depend system table is associated with the file DEPEND.DDF. X$Depend contains information about trigger dependencies such as tables, views, and procedures. The structure of X$Depend is as follows:
Table C-25 X$Depend System Table Structure
| Column Name |
Type |
Size |
Case Insensitive |
Description |
| Xd$Trigger |
CHAR |
30 |
Yes |
Name of trigger. It corresponds to Xt$Name in X$Trigger. |
| Xd$DependType |
UNSIGNED |
1 |
N/A |
1 for Table, 2 for View, 3 for Procedure. |
| Xd$DependName |
CHAR |
30 |
Yes |
Name of dependency with which the trigger is associated. It corresponds to either Xf$Name in X$File, Xv$Name in X$View, or Xp$Name in X$Proc. |
Two indexes are defined for the X$Depend table, as follows:
Table C-26 X$Depend System Table Index Definitions
| Index Number |
Segment Number |
Column Name |
Dupli-cates |
Case Insensitive |
Segmented |
| 0 |
0 |
Xd$Trigger |
No |
Yes |
Yes |
| 0 |
1 |
Xd$DependType |
No |
N/A |
Yes |
| 0 |
2 |
Xd$DependName |
No |
Yes |
No |
| 1 |
0 |
Xd$DependType |
Yes |
N/A |
Yes |
| 1 |
1 |
Xd$DependName |
Yes |
Yes |
No |
Index Number corresponds to the value stored in the Xi$Number column in the X$Index system table. Segment Number corresponds to the value stored in the Xi$Part column in the X$Index system table.
