Delete Tank Strapping elements

This procedure describes how to delete elements from the Tank Strapping table. In the Tank Strapping application (part of the tank Row Edit in the Advanced Database Editor (ADE)), these are known as rows. If your end goal is to delete the Tank Strapping table entirely, you must first delete all of the elements contained in the table first.

Note: As stated above, while this procedure will guide you through element deletion using Microsoft SQL Server Management Studio, it is preferred that you delete the rows using the Tank Strapping application.

To delete Tank Strapping elements

1. Open Microsoft SQL Server Management Studio.

2. Do the following to find the ID of the Tank Strapping table to which the elements belong:

   1. Click New Query.

   2. Type the following:

      SELECT [Id] FROM [LiquidTank].[dbo].[TankStrappingTables] where name = '<TankStrappingTableName>'

   3. Replace <TankStrappingTableName> with the name of the table that you wish to delete.

   4. Click Execute.

      This will return an ID for that table. All records that are associated with this Tank Strapping table will use the same ID. You will use this ID to indicate which elements should be deleted.

3. To delete the strapping elements and their associated audit trails, type the following:

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

   DELETE FROM [LiquidTank].[dbo].[TankStrappingElements] WHERE Tankstrappingtableid = '<TankStrappingTableId>'

4. Click Execute.