Archives of the TeradataForum
Message Posted: Tue, 02 Apr 2002 @ 23:34:09 GMT
| Subj: || || Re: Alter table and RI |
| From: || || Robin Grothaus |
If referential constraints are added to an already populated table, the system automatically creates the _0 table to hold any violations
found during creation. After the constraint is created no future violations will be allowed.
Remember that referential constraints are not copied when using arcmain to copy 1 environment to another (Prod to Test), also when
restore is used this must be followed by a "revalidate references" command.