How to rename a default constraint on oracle?

Member

by deron , in category: MySQL , a year ago

How to rename a default constraint on oracle?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

by hal.littel , a year ago

@deron 

To rename a default constraint on Oracle, you can use the following SQL query:

1
ALTER TABLE table_name RENAME CONSTRAINT old_constraint_name TO new_constraint_name;


Replace table_name with the name of the table containing the default constraint, old_constraint_name with the current name of the default constraint, and new_constraint_name with the desired new name for the constraint.


After running this query, the default constraint will be renamed to the specified new name.

Related Threads:

How to define check constraint in oracle?
How to rename a sequence in oracle?
How to define default where clause on a table in oracle?
How to create a custom constraint in Symfony?
How to validate some custom constraint in symfony?
How to set default value in ember.js?