<pre class="ip-ubbcode-code-pre"> Alter Table [MyTable] Drop [myConstraint] </pre><BR><BR>Right?<BR><BR>Anyways, I know I figured out how to do it before, and that it ...

SQL Server allows you to define cascading referential integrity constraints. These actions have a trickle-down or cascading effect, sometimes affecting several tables that were related to the ...

I've got an interesting constraint I'm trying to add ... if there is a more elegant way to do this in T-SQL (SQL2005, FWIW) We have two related tables to hold data on a master class in one table ...

Analyze database contents using basic, intermediate and advanced SQL statement syntax and usage. Demonstrate capability to query data from multiple tables using SQL JOINS. Create and modify database ...