db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jun Li" <allanju...@gmail.com>
Subject Re: Can't drop unique index on SQL Server.
Date Tue, 25 Jul 2006 04:26:54 GMT
I meant the unique indexes created by defining unique constraints.
For other unique indexes should still use DROP INDEX table_name.index_name.


On 7/25/06, Thomas Dudziak <tomdzk@gmail.com> wrote:
>
> On 7/24/06, Jun Li <allanjunli@gmail.com> wrote:
>
> > Unique index on SQL Server is used for UNIQUE KEY constraint
> enforcement,
> > therefore, instead of using DROP INDEX index_name; should use ALTER
> TABLE
> > table_name DROP CONSTRAINT index_name;
>
> Please create a JIRA issue and target it for 1.0.
>
> Tom
>



-- 
--------------
Cheers,
Jun

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message