[jira] Created: (DDLUTILS-256) MS SQL Server: dropping a unique constraint must be done by an ALTER TABLE command

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[jira] Created: (DDLUTILS-256) MS SQL Server: dropping a unique constraint must be done by an ALTER TABLE command

JIRA jira@apache.org
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


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 | Threaded
Open this post in threaded view
|

[jira] Updated: (DDLUTILS-256) MS SQL Server: dropping a unique constraint must be done by an ALTER TABLE command

JIRA jira@apache.org

     [ 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.