Release 2.7
Splice Machine SQL Manual
Identifiers
Data Types
- Introduction
- BIGINT
- BLOB
- BOOLEAN
- CHAR
- CLOB
- DATE
- DECIMAL
- DOUBLE
- DOUBLE PRECISION
- FLOAT
- INTEGER
- LONG VARCHAR
- NUMERIC
- REAL
- SMALLINT
- TEXT
- TIME
- TIMESTAMP
- VARCHAR
Statements
Clauses
- Introduction
- CONSTRAINT
- EXCEPT
- FROM
- GROUP BY
- HAVING
- LIMIT n
- ORDER BY
- OVER
- RESULT OFFSET and FETCH FIRST
- TOP n
- UNION
- USING
- WHERE
- WITH
Expressions
Join Operations
Queries
SQL Built-in Functions
- Introduction
- ABS
- ACOS
- ADD_MONTHS
- ASIN
- ATAN
- ATAN2
- AVG
- BIGINT
- CAST
- CEIL
- CHAR
- COALESCE
- Concatenation Operator
- COS
- COSH
- COT
- COUNT
- CURRENT SCHEMA
- CURRENT_DATE
- CURRENT_ROLE
- CURRENT_TIME
- CURRENT_TIMESTAMP
- CURRENT_USER
- DATE
- DAY
- DEGREES
- DENSE_RANK
- DOUBLE
- EXP
- EXTRACT
- FIRST_VALUE
- FLOOR
- HOUR
- INITCAP
- INSTR
- INTEGER
- LAG
- LAST_DAY
- LAST_VALUE
- LCASE
- LEAD
- LENGTH
- LN (or LOG)
- LOCATE
- LOG10
- LTRIM
- MAX
- MIN
- MINUTE
- MOD
- MONTH
- MONTHNAME
- MONTH_BETWEEN
- NEXT_DAY
- NOW
- NULLIF
- NVL
- PI
- QUARTER
- RADIANS
- RAND
- RANDOM
- RANK
- REGEXP_LIKE
- REPLACE
- ROUND
- ROWID
- ROW_NUMBER
- RTRIM
- SECOND
- SESSION_USER
- SIGN
- SIN
- SINH
- SMALLINT
- SQRT
- STDDEV_POP
- STDDEV_SAMP
- SUBSTR
- SUM
- TAN
- TANH
- TIME
- TIMESTAMP
- TIMESTAMPADD
- TIMESTAMPDIFF
- TO_CHAR
- TO_DATE
- TRIM
- TRUNCATE
- UCASE or UPPER
- USER
- VARCHAR
- WEEK
- YEAR
System Procedures
System Tables
Error Codes

RENAME INDEX

The RENAME INDEX statement allows you to rename an index in the current schema. Users cannot rename indexes in the SYS schema.

Syntax

RENAME INDEX index-Name TO new-index-Name

index-Name

The name of the index to be renamed.

new-Index-Name

The new name for the index.

Example

splice> RENAME INDEX myIdx TO Player_index;
0 rows inserted/updated/deleted

See Also

ALTER statement