@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.