Configuring check constraint and row violation logging using error tables

A method comprising:

• decoding, by at least one hardware processor, a query received at a network-based database system, the query including a command to perform an operation on a base table;
• retrieving an integrity constraint associated with the base table, the integrity constraint specifying a desired configuration for the base table;
• performing a verification of the integrity constraint to detect erroneous data of the base table, the erroneous data violating the desired configuration;
• inputting the erroneous data into an error table, the error table being configured as a dynamic table maintained as a nested object of the base table;
• and
• generating a notification that the erroneous data is available in the error table.

A computer-storage medium comprising instructions that, when executed by one or more processors of a machine, configure the machine to perform operations comprising:

• decoding a query received at a network-based database system, the query including a command to perform an operation on a base table;
• retrieving an integrity constraint associated with the base table, the integrity constraint specifying a desired configuration for the base table;
• performing a verification of the integrity constraint to detect erroneous data of the base table, the erroneous data violating the desired configuration;
• inputting the erroneous data into an error table, the error table being configured as a dynamic table maintained as a nested object of the base table;
• and
• generating a notification that the erroneous data is available in the error table.