[ http://issues.apache.org/jira/browse/DDLUTILS-127?page=comments#action_12455261 ] Christoffer Hammarström commented on DDLUTILS-127: --------------------------------------------------
I think i was using dropTable() directly, but i'm not sure. > MsSqlBuilder does not drop foreign keys to a table before dropping the table. > ----------------------------------------------------------------------------- > > Key: DDLUTILS-127 > URL: http://issues.apache.org/jira/browse/DDLUTILS-127 > Project: DdlUtils > Issue Type: Bug > Components: Core - SqlServer > Reporter: Christoffer Hammarström > Assigned To: Thomas Dudziak > Fix For: 1.0 > > Attachments: DDLUTILS-127.patch > > > Could not drop object 'Tmp_categories' because it is referenced by a FOREIGN > KEY constraint. Query: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' > AND name = 'Tmp_categories') > BEGIN > DECLARE @tablename nvarchar(256), @constraintname nvarchar(256) > DECLARE refcursor CURSOR FOR > SELECT object_name(objs.parent_obj) tablename, objs.name constraintname > FROM sysobjects objs JOIN sysconstraints cons ON objs.id = cons.constid > WHERE objs.xtype != 'PK' AND object_name(objs.parent_obj) = > 'Tmp_categories' OPEN refcursor > FETCH NEXT FROM refcursor INTO @tablename, @constraintname > WHILE @@FETCH_STATUS = 0 > BEGIN > EXEC ('ALTER TABLE '[EMAIL PROTECTED]' DROP CONSTRAINT '[EMAIL > PROTECTED]) > FETCH NEXT FROM refcursor INTO @tablename, @constraintname > END > CLOSE refcursor > DEALLOCATE refcursor > DROP TABLE Tmp_categories > END; -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira