<p>I continue to get this error:</p>

<pre><code>Object '%s' cannot be renamed because the object participates in enforced dependencies
</code></pre>

<p>I need to find a script that will help me to find all the dependencies that there is with this table. I will need to drop them, rename, then bring them back.</p>

<p>SQL Server 2005</p>

To disable all contraints
```
```
sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"
go
sp_msforeachtable "ALTER TABLE ? DISABLE TRIGGER  all"
go
```
```
To Re-enable
```
```
sp_msforeachtable"ALTER TABLE ? CHECK CONSTRAINT all"
go
sp_msforeachtable "ALTER TABLE ? ENABLE TRIGGER  all"
go
```
```
You should easily be able to adapt this to just one table.