CONSTRAINT hammers_cant_wrench CHECK Mid(WrenchingTool,1,1) = "W" ); I don't like it, but I guess I'll throw out normalization for the sake of expediency. I still welcome elegant solutions.

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.

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 ...