Example: Creating a Named Error Table
The following example creates an error table named e for data table t.
CREATE ERROR TABLE e FOR t;
Example: Creating an Error Table for a Row-Level Security Table
The following example creates an error table named err_table_1 for the row-level security constraint-protected data table named table_1_RLS_constraints, but does not generate any row-level security columns for the error table because the request specifies the NO RLS option.
CREATE ERROR TABLE err_table_1 FOR table_1_RLS_constraints NO RLS;
- database_name
- user_name
- Name of the database or user in which the data table is contained if not in the current database or user.
Example: Creating an Error Table with a Default Name
The following example creates an error table with a default name of et_t for data table t.
CREATE ERROR TABLE FOR t;