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 the following points when using the DROP TABLE command:

   • Escaped table names are not supported.
     Note: In SQL, an escaped name is a sequence of one or more characters enclosed within SQL escape characters. Trailing spaces are insignificant. Special characters used within the escaped name must themselves be escaped.
   • Object names (for example, <table_name>) are case insensitive. ActiveSpaces converts all object names to lowercase prior to executing the command.