DROP SECONDARY INDEX
Function
This command is used to delete the existing secondary index table in a specific table.
Syntax
DROP INDEX [IF EXISTS] index_name ON [db_name.]table_name;
Parameter Description
Parameter |
Description |
---|---|
index_name |
Name of the index table. Table name contains letters, digits, and underscores (_). |
db_Name |
Name of the database. If the parameter is not specified, the current database is used. |
table_name |
Name of the table to be deleted. |
Usage Guidelines
In this command, IF EXISTS and db_name are optional.
Examples
DROP INDEX if exists productNameIndexTable ON productdb.productSalesTable;
System Response
Secondary Index Table will be deleted. Index information will be cleared in CarbonData table and the success message will be recorded in system logs.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.