Restrictions and Considerations
• You cannot use copy to add data to a view, index, or system catalog.
• When copying data into a table, copy ignores any integrity constraints (defined using the define integrity statement) defined against the table.
• When copying data into a table, copy ignores ANSI/ISO Entry SQL-92 check and referential constraints, but does not ignore unique (and primary key) constraints. For details about ANSI/ISO table constraints, see the SQL Reference Guide.
• The copy statement does not fire any rules defined against the table.
Last modified date: 08/14/2024