Backup and Restore 2 Manual

BRCOM BACKUP Command
Backup and Restore 2 Manual—522696-019
6-28
CONSTRAINTS Job Option

If you specify CONSTRAINTS EXCLUDED, you must specify the INDEXES
EXCLUDED.

The constraints that are backed up varies depending on whether you specify
CONSTRAINTS INCLUDED or CONSTRAINTS EXCLUDED:.

You cannot directly back up referential integrity constraints. For more information,
see Restore of Views, Stored Procedures, Triggers, and Referential Integrity
Constraints on page 1-13. However, the data definition language (DDL) for these
constraints is automatically backed up. You can use the RESTORE SHOWDDL
ON option to generate one or more OSS edit files containing DDL information. Use
the DDL to recreate the referential integrity constraints. Also, you can use the
OBEYDDL job option to automatically create the referential integrity constraints
using the OSS edit files containing the DDL information.
CONSTRAINTS INCLUDED EXCLUDED
Check Yes No
Not Null Yes Yes
Unique Yes No
Primary key droppable Yes No
Primary key not droppable Yes Yes
Referential integrity No No
Note. The OBEYDDL job option is supported only on SQL/MX 3.2 version and above.