Delete the Tank Strapping tables

After you have deleted the elements associated with the Tank Strapping table, you can proceed to delete the Tank Strapping table itself.

To delete the Tank Strapping tables

1. Click New Query.

2. Type the following:

   DELETE FROM [LiquidTank].[dbo].[TankStrappingTables_Audit] WHERE tankstrappingtableid = '<TankStrappingTableId>'

   DELETE FROM [LiquidTank].[dbo].[TankStrappingRevisions] WHERE tankstrappingtableid = '<TankStrappingTableId>'

   DELETE FROM [LiquidTank].[dbo].[TankStrappingTables] WHERE Id = '<TankStrappingTableId>'

3. Click Execute.

4. All of the data should now be removed from the database. Do the following to confirm that you have successfully removed the Tank Strapping table from the database:

   1. In Advanced Database Editor (ADE), open the tank Row Edit that your Tank Strapping Table is associated with.

   2. Navigate to the Level to Volume tab.

   3. Click Edit Strapping Tables.

      The View Strapping Tables window appears.

   4. Check to ensure that the Tank Strapping Table name that you deleted is no longer listed.