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. An escaped name is case sensitive and 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.