Open topic with navigation

TIBCO ActiveSpaces® 4.8.0

# Dropping a Table

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

Procedure
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.

Copyright © 2009-2022. Cloud Software Group, Inc. All Rights Reserved.