This command is used to delete the existing secondary index table in a specific table.

DROP INDEX [IF EXISTS] index_name ON [db_name.]table_name;

**Table 1** DROP SECONDARY INDEX parameters
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.

In this command, IF EXISTS and db_name are optional.

DROP INDEX if exists productNameIndexTable ON productdb.productSalesTable;

Secondary Index Table will be deleted. Index information will be cleared in CarbonData table and the success message will be recorded in system logs.

DROP SECONDARY INDEX