4. SQL Statements : DROP SECURITY_ALARM
 
Share this page                  
DROP SECURITY_ALARM
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The DROP SECURITY_ALARM statement deletes security alarms for a table, database, or current installation.
Syntax
The DROP SECURITY_ALARM statement has the following format:
[EXEC SQL] DROP SECURITY_ALARM ON [TABLE] table_name |
             DATABASE dbname | CURRENT INSTALLATION | ALL |
               integer {, integer} | alarm_name {, alarm_name}
ALL
Deletes all security alarms for the specified table, database, or current installation.
integer (, integer)
Deletes the security alarms identified by the specified numeric ID. To see the numeric ID, use the HELP SECURITY_ALARM statement.
alarm_name (, alarm_name)
Deletes the security alarms identified by the specified alarm name.