The preceding example creates a referential integrity constraint between variable Name in table ONE and variable Lname in table TWO. As the primary key, variable Name will define the acceptable data ...

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