How to modify constraints in Oracle Database

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

Видео How to modify constraints in Oracle Database автора MySQL Инвестигатор