Dropping a Table

Use this procedure when the Client no longer uses a DATABridge data table in the relational database.

To drop a table from the Client Console, see the DATABridge Client Console Help.

To drop a table

1. Update your data set selection script and data table customization script, depending on whether you are dropping a primary or secondary table, to reflect this change. See Customizing with User Scripts.
2. If you are dropping all of the tables derived from a data set, set the active column corresponding to the data set to 0 (in the DATASETS client control table) and then run the data set selection script (script.user_datasets.datasource) using the dbutility redefine command.
3. If you are dropping a secondary table, set the active column corresponding to the table to 0 (in the DATATABLES client control table) and then run the data table customization script (script.user_define.primary_tablename) for the primary table using the redefine command.
4. From a command line, set the current directory to the working directory for the data source, and then run a script, such as the following (Windows)

   dbutility -n runscript dbscripts\script.drop.tablename