<div>
I changed the order of my DROPS so that all the children were dropped first, then the parent, and I no longer get these messages. <br />
I'm going to wait a couple of days to make sure that is correct. <br />
<br />
Thanks.<br />
Jim
</div>


I changed the order of my DROPS so that all the children were dropped first, then the parent, and I no longer get these messages.
I'm going to wait a couple of days to make sure that is correct.

Thanks.
Jim

<div>
Haven't had a chance to circle back to this, sorry, but reordering the DROPs based on child-parent order seems to have worked. &nbsp;Thanks.
</div>


Haven't had a chance to circle back to this, sorry, but reordering the DROPs based on child-parent order seems to have worked.  Thanks.

<div>
<div class="content wysiwyg-content">
Hi guys<br />
<br />
Question: &nbsp;When you drop a table, how do you ensure that you drop every constraint on the table first? <br />
<br />
&lt;pseudo code&gt;<br />
<br />
IF OBJECT_ID('log.EXECUTIONS'<wbr />,'U') IS NOT NULL<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;begin<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALTER TABLE log.EXECUTIONS DROP CONSTRAINT &lt;every friggin' constraint on the table&gt; &nbsp; -- &nbsp;&lt;-- &nbsp;Here<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DROP TABLE log.EXECUTIONS<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;end<br />
GO<br />
<br />
Thanks in advance.<br />
Jim
</div>
</div>


Hi guys

Question:  When you drop a table, how do you ensure that you drop every constraint on the table first? 

<pseudo code>

IF OBJECT_ID('log.EXECUTIONS','U') IS NOT NULL
	begin
	ALTER TABLE log.EXECUTIONS DROP CONSTRAINT <every friggin' constraint on the table>   --  <--  Here
	DROP TABLE log.EXECUTIONS
	end
GO

Thanks in advance.
Jim

DROP every constraint

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.