Databases - Oracle Constraint Naming Standards

A constraint naming standard is important for one primary reason: The SYS_* name Oracle assigns to unnamed constraints is not very understandable. By correctly naming all constraints, we can quickly associate a particular constraint with our data model. This gives us two real advantages:

* We can quickly identify and fix any errors
* We can reliably modify or drop constraints

Why do we need a naming convention? Oracle limits names, in general, to 30 characters, which is hardly enough for a human-readable constraint name.
Constraint Naming Standards