Dropping a Table

When you no longer want a DATABridge data table in the relational database, you can drop the table. You can drop tables from the Client Console (see DATABridge Client Console Help). You can also drop a table by running a script.

Windows example:

dbutility -n runscript drive:\directory\script.drop.tablename

Then, 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.

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). Do this via the data set selection script (script.user_datasets.datasource).

If you are dropping a secondary table, set the active column corresponding to the table to 0 (in the DATATABLES client control table). Do this via the data table customization script (script.user_define.primary_tablename) for the primary table.