Dropping unique index properly on SQL Server.
---------------------------------------------
Key: DDLUTILS-119
URL: http://issues.apache.org/jira/browse/DDLUTILS-119
Project: DdlUtils
Issue Type: Bug
Components: Core - SqlServer
Affects Versions: 1.0
Reporter: Jun Li
Assigned To: Thomas Dudziak
On SQL Server, some unique indexes are created automatically to enforce the
UNIQUE constraint.
For this kind of unique index, we cannot use DROP INDEX command to remove them,
should use ALTER TABLE table_name DROP CONSTRAINT index_name instead.
--
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