Was this helpful?
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: 11/28/2023