Skip to Main Content

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. Join this session to learn how to make these changes while the application is online & keep your data safe!

Resources

Featured Speakers

  • Speaker

    Chris Saxon


    Oracle Developer Advocate for SQL

Workshop Info

Session Has Completed - 18 July 2023
1 Hour
Write Great SQL Office Hours
English
SQL

Other Upcoming Sessions