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

        

Reply via email to