You can indeed change, with SQL 2000.<BR><BR>But I'm running into problems with the constraints when I attempt to do so.<BR><BR>I was hoping for a way to do this without having to drop and ...

Check constraints are supported in all of the major DBMS products, including DB2, Oracle, and SQL Server. But they are too-often ignored and not implemented in production databases. Properly defined, ...

In particular, I often look up constraints in SQL*Plus. In this post, I look at the Oracle database views and queries that I use most to get an idea what constraints I am dealing with.