From time to time, you may need to change a constraint. For example, adding values to a CHECK constraint IN list or changing the columns in a unique constraint.

Sadly there's no syntax to make these changes. You need to drop and recreate the constraint with the new criteria.

Watch the recording to learn how to make these changes while the application is online & keep your data safe!

Highlights include:

- 00:30 The problem with changing constraints
- 03:00 Reasons for changing constraints
- 12:20 Changing CHECK constraints
- 20:00 Demo of changing CHECK constraints
- 30:10 Adding/removing NOT NULL constraints
- 33:00 Changing columns in a UNIQUE constraints
- 35:30 Demo changing NOT NULL & UNIQUE
- 39:00 Changing PRIMARY KEY
- 43:30 Changing FOREIGN KEY
- 47:35 Adding a surrogate key to a table
- 53:30 Demo changing PRIMARY & FOREIGN keys
- 57:30 Summary

Read the blog post https://bit.ly/change-constraint-blog
Get the scripts https://bit.ly/SQL-ATOH-change-constraints-script

Learn SQL for free https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations .html