The Association view contains information about entities that were restored using the Archive and Recovery COPY utility. If a copied object is subsequently dropped, the information is deleted and is no longer available.
Corresponding Tables
The X view references these additional tables:
- DBC.AccessRights
- DBC.Owner
- DBC.RoleGrants
- DBC.Roles
Possible Values for Original_JournalFlag
| Value | Description |
|---|---|
| N | No Journal |
| S | Single Journal |
| D | Dual Journal |
| L | Local AFTER journal (non used for BEFORE) |
Possible Values for Original_TableKind
| Value | Description |
|---|---|
| T | Data Table |
| V | View |
| M | Macro |
| J | Journal Table |
| I | Join Index Table |
| P | Stored Procedure |
| G | Trigger |
| F | Scalar UDF |
| A | Aggregate UDF |
| N | Hash Index Table |
| U | User-defined Type |
| H | Instance or Constructor Method |
| E | External Stored Procedure |
| R | Table Function |
| X | Authorization |