Ars Tribunus Angusticlavius 18y 9,633 Mar 29, 2010 #3 my only suggestion is a tables Orders, HammeringTools, WrenchingTools and Tools. Orders has FK to Hammering and wrenching (from the relevant ...

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

Cascading referential integrity constraints are foreign key constraints that tell SQL Server to perform certain actions when a primary key field in a primary key-foreign key relationship is ...

Many databases provide or use system tables that enable queries to return the list of available tables, columns, procedures, and other useful information. In OLE DB, much of this functionality is ...