Ars Legatus Legionis 24y 11,116 Mar 29, 2010 #2 You'd need to effectively have a one-column table, say, "wrenches", that listed only wrenching tools (with a foreign key constraint to "tools"), and ...

In particular, this simple query shows the constraints for a given table that are foreign key constraints and which primary key constraints they depend on. displayForeignKeyConstraints.sql ...

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