Application information tables store settings related to the database session failover functionality set in a Web application.

The procedures for deleting the application information table are as follows:

1. Copy the template file to any location.
   A template file is provided as an SQL file used for deleting a table. The storage locations of the template files for each used database are:
   
   • Storage location of template files when using HiRDB
     In Windows: Application-Server-installation-directory\CC\sfo\sql\hirdb_delete_apptbl.sql
     In UNIX: /opt/Cosminexus/CC/sfo/sql/hirdb_delete_apptbl.sql
     
   • Storage location of template files when using Oracle
     In Windows: Application-Server-installation-directory\CC\sfo\sql\oracle_delete_apptbl.sql
     In UNIX: /opt/Cosminexus/CC/sfo/sql/oracle_delete_apptbl.sql
     
2. Edit the template file.
   Edit the template file in accordance with the preference information for a Web application and create an SQL file used for deleting a table. The following table describes change locations and change contents in a template file.
   

   Table 6-55 Change locations and change contents in a template file

   Change location		Change target	Change contents
   HiRDB	Oracle
   First line	First line	APPLICATION_ID	Change the application identifier of the application to be used.
   None	First line	SCHEMA_NAME	Change the schema name of user connected to database.

3. Execute the SQL file created for table deletion.
   For executing the SQL file, use SQL Executer when using HiRDB and SQL*Plus when using Oracle.