Truncate All Tables

Truncate ALL tables

It is possible to truncate all data in every table owned by the database user cow_owner.

Guidelines

• Every row and data in the tables will be deleted and no recovery is possible.

• All triggers and constrains will automatically be disabled and then enabled during this operation.

• The task can take up to several minutes before it is finished.

Finding information

Some of the information required for this tool can be found on the Standard Information screen of the View Info Tool.

The Company name can be found in Application Settings in OSM Admin.

Truncate all tables

1. Select the Truncate ALL tables radio button.

2. Enter the following information.

   • OSM version - Full version number of OSM.

   • OSM DB name - The name of the OSM database.

   • Company name - The official company name as listed in Application Settings of OSM Administration.

     The tool will check the entered values to see if they match the corresponding values in the database. If not, then the task will not be performed.

3. (Optional) It is also possible to enter the database identifier in the DB ID field, instead of database information values.

   

4. Click Truncate tables to perform the task.

5. A confirmation dialog box appears. Click Yes to continue.

   

   When the operation is complete, a message displays at the bottom of the screen.