image

image

onstraints are critical components in databases. They restrict (constrain) what you can add, modify, or delete from tables with INSERT, UPDATE, and DELETE statements. Constraints let you restrict what can be placed in columns, rows, tables, or relationships between tables. That’s a tremendously broad statement that requires some qualification. So what are these restrictions and why are they important?

As with the prior chapter, this chapter develops what and why before delving into the SQL implementation of database constraints that work with ...

Get Oracle Database 11g & MySQL 5.6 Developer Handbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.