Help Center/ GaussDB(DWS)/ Tool Guide/ DSC/ SQL Syntax Migration Reference/ MySQL Syntax Migrating/ Schema Objects and Data Definition Language (DDL)/ Indexes/ Renaming an Index
Updated on 2024-07-19 GMT+08:00
View PDF
Share

Renaming an Index

DSC supports renaming indexes. Prefix a table name to an index name to prevent name conflicts. (Only DDL statements with specific index names can be created. Currently, the name of a renamed index cannot be deleted. Exercise caution when modifying this parameter.)

Modifying the configuration

Open Table 1 Configuration parameters in the features-mysql.properties file and change the value of the following parameter to true: The default value is false, indicating that the file will not be renamed.

1
2
 
# Whether to rename an index when creating the index.
table.index.rename=true

Input

1
2
3
4
5
6
 
CREATE TABLE IF NOT EXISTS `CUSTOMER`(    
    `NAME` VARCHAR(64) PRIMARY KEY,   
    ID INTEGER,   
    ID2 INTEGER);
CREATE INDEX ID_INDEX USING BTREE ON CUSTOMER (ID);
ALTER TABLE CUSTOMER ADD INDEX ID3_INDEX(ID2);

Output

1
2
3
4
5
6
 
CREATE TABLE IF NOT EXISTS "public"."customer" ( 
    "name" VARCHAR(256) PRIMARY KEY,  
    "id" INTEGER,  
    "id2" INTEGER) WITH (ORIENTATION = ROW, COMPRESSION = NO) NOCOMPRESS DISTRIBUTE BY HASH ("name");
CREATE INDEX customer_id_index ON "public"."customer" USING BTREE ("id");
CREATE INDEX customer_id3_index ON "public"."customer" ("id2");
Parent topic: Indexes