How to rename a sequence in oracle?

Member

by orpha , in category: Third Party Scripts , 4 months ago

How to rename a sequence in oracle?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

by muriel.schmidt , 4 months ago

@orpha 

To rename a sequence in Oracle, you can use the following command:


ALTER SEQUENCE old_sequence_name RENAME TO new_sequence_name;


Replace "old_sequence_name" with the current name of the sequence and "new_sequence_name" with the desired new name for the sequence. This command will rename the sequence in the database. Remember to make sure you have the necessary privileges to alter the sequence.

Related Threads:

How to create order sequence in oracle?
How to add prefix string to sequence in oracle?
How to insert 2 queries with sequence in oracle?
How to get value from string sequence column in oracle?
How to rename a default constraint on oracle?
How to set unset sequence in php?