Name of the data table for which the error table to be dropped is defined.
This syntax is particularly useful if you did not define a name for the error table to be dropped and you do not know its system-assigned default name.
- database_name
- user_name
- The containing database or user for the specified data table if it is defined in a database other than the current database.
Example: Dropping an Error Table
This example deletes the error table defined on the orders table.
DROP ERROR TABLE FOR orders;