renameSequence
Renames an existing sequence.
Available attributes
Name | Description | Required for | Supports | Since |
---|---|---|---|---|
catalogName
|
Name of the catalog | all | 3.0 | |
newSequenceName
|
New name for the sequence | all | all | |
oldSequenceName
|
Name of the sequence to rename | all | all | |
schemaName
|
Name of the schema | all |

<changeSet author="liquibase-docs" id="renameSequence-example">
<renameSequence catalogName="cat"
newSequenceName="seq_id"
oldSequenceName="seq_id"
schemaName="public"/>
</changeSet>

changeSet:
id: renameSequence-example
author: liquibase-docs
changes:
- renameSequence:
catalogName: cat
newSequenceName: seq_id
oldSequenceName: seq_id
schemaName: public

{
"changeSet": {
"id": "renameSequence-example",
"author": "liquibase-docs",
"changes": [{
"renameSequence": {
"catalogName": "cat",
"newSequenceName": "seq_id",
"oldSequenceName": "seq_id",
"schemaName": "public"
}
}]
}
}

sp_rename seq_id ,
seq_id;
Database support
Database | Notes | Auto rollback |
---|---|---|
DB2/LUW | Not Supported | No |
DB2/z | Not Supported | No |
Derby | Not Supported | No |
Firebird | Not Supported | No |
H2 | Not Supported | No |
HyperSQL | Not Supported | No |
INGRES | Not Supported | No |
Informix | Not Supported | No |
MariaDB | Not Supported | No |
MySQL | Not Supported | No |
Oracle | Supported | Yes |
PostgreSQL | Supported | Yes |
Snowflake | Supported | Yes |
SQL Server | Supported | Yes |
SQLite | Not Supported | No |
Sybase | Not Supported | No |
Sybase Anywhere | Supported | Yes |