You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-dev@db.apache.org by "Tom Palmer (JIRA)" <ji...@apache.org> on 2010/04/25 19:49:49 UTC
[jira] Created: (DDLUTILS-256) MS SQL Server: dropping a unique
constraint must be done by an ALTER TABLE command
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.
[jira] Updated: (DDLUTILS-256) MS SQL Server: dropping a unique
constraint must be done by an ALTER TABLE command
Posted by "Tom Palmer (JIRA)" <ji...@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.