Open topic with navigation

TIBCO ActiveSpaces® - Enterprise Edition 5.0.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 running the command.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO ActiveSpaces® - Enterprise Edition

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