# Documentation bug for dropTable

**URL:** <https://forum.liquibase.org/t/documentation-bug-for-droptable/3108>\
**Category:** General Discussion\
**Created:** [September 16, 2014, 6:39pm UTC](https://forum.liquibase.org/t/documentation-bug-for-droptable/3108 "2014-09-16T18:39:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![hans.castorp](https://avatars.discourse-cdn.com/v4/letter/h/74df32/32.png) [@hans.castorp](https://forum.liquibase.org/u/hans.castorp)\
**Post date:** [September 16, 2014, 6:39pm UTC](https://forum.liquibase.org/t/documentation-bug-for-droptable/3108/1 "2014-09-16T18:39:00Z")

</div>

Hello,

the documentation for dropTable states that the attribute “cascadeConstraints” is supported for all DBMS.

At least for SQL Server this is not true

Consider the following changeLog:

1. \<?xml version="1.0" encoding="utf-8"?\>
2. http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd" 
3. &nbsp;&nbsp;&nbsp; xmlns:xsi="[http://www.w3.org/2001/XMLSchema-instance"](http://www.w3.org/2001/XMLSchema-instance%22) 
4. &nbsp;&nbsp;&nbsp; xmlns="[http://www.liquibase.org/xml/ns/dbchangelog"\>](http://www.liquibase.org/xml/ns/dbchangelog%22>)
5. 
6. 
7. &nbsp;&nbsp; 
8. &nbsp;&nbsp;&nbsp;&nbsp; 
9. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \<constraints nullable="false" 
10. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; primaryKey="true" 
11. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; primaryKeyName="pk\_bar" /\>
12. &nbsp;&nbsp;&nbsp;&nbsp; 
13. &nbsp;&nbsp; 
14. 
15. &nbsp;&nbsp; 
16. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
17. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
18. &nbsp;&nbsp; 
19. 
20. &nbsp;&nbsp; \<addForeignKeyConstraint constraintName="fk\_bar\_foo" 
21. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; baseTableName="foo" baseColumnNames="bar\_id" 
22. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; referencedTableName="bar" referencedColumnNames="id" /\>
23. &nbsp;&nbsp; 
24. 
25. &nbsp; 
26. &nbsp;&nbsp;&nbsp; 
27. &nbsp; 
28. 
29.  

 The changeSet id="2" will fail with the error message:

_Error executing SQL DROP TABLE [dbo].[bar]: Could not drop object ‘dbo.bar’ because it is referenced by a FOREIGN KEY constraint._

To my knowledge this only works on Postgres, Oracle, DB2, H2 and HSQLDB.