Dropping a Table

Use the SQL command DROP TABLE to remove a table and the data from the data grid.

1. Compose a string with the following format:

   DROP TABLE [ IF EXISTS ] <table_name>

2. Pass the string to the ExecuteUpdate method of the tibdgSession object.
   For example:

   DROP TABLE myTable
   DROP TABLE IF EXISTS myTable

   Note: When using the DROP TABLE command, object names (for example, <table_name>) are case insensitive. ActiveSpaces converts all object names to lowercase before executing the command.