Help Center/ Distributed Database Middleware/ User Guide/ SQL Syntax/ Supported SQL Statements/ HINT- ALLOW_ALTER_RERUN
Updated on 2023-10-09 GMT+08:00
View PDF
Share

HINT- ALLOW_ALTER_RERUN

Command Format:

/*+ allow_alter_rerun=true*/<ALTER TABLE>

Description:

Using this hint ensures that commands can be repeatedly executed, and no errors are reported. This hint supports the following ALTER TABLE statements: ADD COLUMN, MODIFY COLUMN, DROP COLUMN, ADD INDEX, DROP INDEX, CHANGE COLUMN, ADD PARTITION, and DROP PARTITION.

Example:

/*+ allow_alter_rerun=true*/ALTER TABLE aaa_tb ADD schoolroll varchar(128) not null comment 'Enrollment data'

Parent topic: Supported SQL Statements