Permanently deleting a Application Security database

If, at some point, you plan to remove Application Security altogether, you can remove the Application Security database. To permanently delete a Application Security database schema along with all the data in the database, you run the drop‑tables.sql script.

 Running the drop-tables.sql script permanently removes the Application Security database schema and all the data in the database. Ensure you have backed up any data you want to save before running this script.

To delete the Application Security database schema and all the data in the database:

  1. Go to the <ssc_distribution_dir>/sql/ directory, and open the subdirectory for the third-party database you plan to use with Application Security:

    • mysql

    • Oracle

    • sqlserver

  2. Copy the drop‑tables.sql script from the subdirectory that matches your Application Security database type to the database server or other location where you will run the script.

  3. In the database client program, log into the database account you created for use with Application Security.

  4. Review the caution in the introduction to this topic.

  5. Remove the Application Security database schema and all the data in the database by running the following script:

    drop-tables.sql