ALTER INDEX

// Renaming the index
create.alterIndex("old_index").renameTo("new_index").execute();

alterIndex("i").renameTo("j")

-- ASE
EXEC sp_rename 'i', j, 'index'

-- AURORA_MYSQL, MARIADB, MEMSQL, MYSQL
ALTER TABLE  RENAME INDEX i TO j

-- AURORA_POSTGRES, COCKROACHDB, H2, HSQLDB, ORACLE, POSTGRES
ALTER INDEX iRENAME TO j

-- DB2, DERBY, HANA
RENAME INDEX iTO j

-- SQLDATAWAREHOUSE, SQLSERVER
EXEC sp_rename 'i', j, 'INDEX'

-- ACCESS, BIGQUERY, DUCKDB, EXASOL, FIREBIRD, INFORMIX, REDSHIFT, SNOWFLAKE, SQLITE, SYBASE, TERADATA, TRINO, VERTICA, 
-- YUGABYTEDB
/* UNSUPPORTED */

// Renaming the index
create.alterIndexIfExists("old_index").renameTo("new_index").execute();

alterIndexIfExists("i").renameTo("j")

-- AURORA_POSTGRES, COCKROACHDB, H2, POSTGRES
ALTER INDEX IF EXISTS iRENAME TO j

-- DB2
BEGIN
  DECLARE CONTINUE HANDLER FOR SQLSTATE '42704' BEGIN END;
  EXECUTE IMMEDIATE '
    RENAME INDEX iTO j
  ';
END

-- HANA
DO BEGIN
  DECLARE EXIT HANDLER FOR SQL_ERROR_CODE 259 BEGIN END;
  EXECUTE IMMEDIATE '
    RENAME INDEX iTO j
  ';
END;

-- MARIADB
BEGIN NOT ATOMIC
  DECLARE CONTINUE HANDLER FOR SQLSTATE '42000' BEGIN END;
  DECLARE CONTINUE HANDLER FOR SQLSTATE '42S02' BEGIN END;
  ALTER TABLE  RENAME INDEX i TO j;
END

-- MYSQL

CREATE PROCEDURE block_1700915494405_3565662()
MODIFIES SQL DATA
BEGIN
  DECLARE CONTINUE HANDLER FOR SQLSTATE '42000' BEGIN END;
  ALTER TABLE  RENAME INDEX i TO j;
END;
CALL block_1700915494405_3565662();
DROP PROCEDURE block_1700915494405_3565662;

-- ORACLE
BEGIN
  EXECUTE IMMEDIATE '
    ALTER INDEX iRENAME TO j
  ';
EXCEPTION
  WHEN others THEN
    IF sqlerrm LIKE 'ORA-01418%' THEN NULL;
    ELSE RAISE;
    END IF;
END;

-- SQLDATAWAREHOUSE
BEGIN TRY
  EXEC sp_rename 'i', j, 'INDEX'
END TRY
BEGIN CATCH
  IF error_number() != 2714 BEGIN
    DECLARE @ErrorMessage NVARCHAR(4000) = ERROR_MESSAGE();
    DECLARE @ErrorSeverity INT = ERROR_SEVERITY();
    DECLARE @ErrorState INT = ERROR_STATE();
    RAISERROR (@ErrorMessage, @ErrorSeverity, @ErrorState);
  END;
END CATCH

-- SQLSERVER
BEGIN TRY
  EXEC sp_rename 'i', j, 'INDEX'
END TRY
BEGIN CATCH
  IF error_number() != 2714 THROW;
END CATCH

-- ACCESS, ASE, AURORA_MYSQL, BIGQUERY, DERBY, DUCKDB, EXASOL, FIREBIRD, HSQLDB, INFORMIX, MEMSQL, REDSHIFT, SNOWFLAKE, 
-- SQLITE, SYBASE, TERADATA, TRINO, VERTICA, YUGABYTEDB
/* UNSUPPORTED */