[ 
https://issues.apache.org/jira/browse/DDLUTILS-256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Tom Palmer updated DDLUTILS-256:
--------------------------------

    Attachment: mssqlserveruniqueconstraints.patch

The attached patch alters the MSSqlBuilder so that the dropIndex method checks 
to see whether the index is unique and, if it is, issues an ALTER TABLE command 
to drop the constraint. If the index isn't unique then a DROP INDEX command 
will be issued.

> MS SQL Server: dropping a unique constraint must be done by an ALTER TABLE 
> command
> ----------------------------------------------------------------------------------
>
>                 Key: DDLUTILS-256
>                 URL: https://issues.apache.org/jira/browse/DDLUTILS-256
>             Project: DdlUtils
>          Issue Type: Bug
>          Components: Core - SqlServer
>    Affects Versions: 1.1
>            Reporter: Tom Palmer
>            Assignee: Thomas Dudziak
>         Attachments: mssqlserveruniqueconstraints.patch
>
>
> Dropping a unique constraint must be performed by issuing an ALTER TABLE 
> command: http://msdn.microsoft.com/en-us/library/ms177420.aspx.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to