REMOVE TABLE
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The REMOVE TABLE statement removes the registration of a security log file.
The REMOVE TABLE statement removes the mapping of a file to a virtual table. To map files to virtual tables, use the REGISTER TABLE statement. The REMOVE TABLE statement removes security log files that were registered using the REGISTER TABLE...AS IMPORT statement.
The REMOVE TABLE statement has the following format:
[EXEC SQL] REMOVE TABLE [schema.]table_name {, [schema.]table_name};
Permissions
You must have SECURITY privilege to remove a table. However, if the target table being removed is a security audit gateway table (that is, was registered with DBMS=SXA), you must have MAINTAIN_AUDIT privilege.
Related Statements
Register Table
REMOVE TABLE Example
Remove a security log registration:
REMOVE TABLE logfile_xyz;