db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jun Li" <allanju...@gmail.com>
Subject Can't drop unique index on SQL Server.
Date Tue, 25 Jul 2006 01:01:59 GMT
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;

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

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