db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jun Li (JIRA)" <j...@apache.org>
Subject [jira] Created: (DDLUTILS-119) Dropping unique index properly on SQL Server.
Date Tue, 25 Jul 2006 04:39:14 GMT
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

        

Mime
View raw message