Jun 102013
 
alter table i_know_my_data_is_rubbish_so
enable novalidate 
constraint so_at_least_new_stuff_is_good;

Creating constraints as novalidated can be a great way to start bringing order to chaos 
if you've inherited a database with no constraints. It can also be useful when business
constraint have changed and you want to leave existing data violating the new constraint.

If you’d like an example of this in practice, just use this script.

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)