Yang, Tong 6182f91ba8 MRS component operation guide_normal 2.0.38.SP20 version

Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Yang, Tong <yangtong2@huawei.com>
Co-committed-by: Yang, Tong <yangtong2@huawei.com>

2022-12-09 14:55:21 +00:00

4.5 KiB

Raw Permalink Blame History

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

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

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.

Parent topic: DML

4.5 KiB Raw Permalink Blame History