Return-Path: Delivered-To: apmail-db-ddlutils-user-archive@www.apache.org Received: (qmail 30071 invoked from network); 25 Jul 2006 04:09:54 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 25 Jul 2006 04:09:54 -0000 Received: (qmail 9259 invoked by uid 500); 25 Jul 2006 04:09:54 -0000 Delivered-To: apmail-db-ddlutils-user-archive@db.apache.org Received: (qmail 9246 invoked by uid 500); 25 Jul 2006 04:09:54 -0000 Mailing-List: contact ddlutils-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ddlutils-user@db.apache.org Delivered-To: mailing list ddlutils-user@db.apache.org Received: (qmail 9235 invoked by uid 99); 25 Jul 2006 04:09:54 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 24 Jul 2006 21:09:54 -0700 X-ASF-Spam-Status: No, hits=0.5 required=10.0 tests=DNS_FROM_RFC_ABUSE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of tomdzk@gmail.com designates 66.249.92.168 as permitted sender) Received: from [66.249.92.168] (HELO ug-out-1314.google.com) (66.249.92.168) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 24 Jul 2006 21:09:53 -0700 Received: by ug-out-1314.google.com with SMTP id m2so2672601uge for ; Mon, 24 Jul 2006 21:09:32 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=aNWHRCBASlL3ibsYMRW+DriAskhreGosrCoHqk8sQqd9+8rv8vBG1HID1vHridRVakcU0hXZlaj7CZQg9xP4IRtsPjcMT04DK1e250Y0uezyxXJs9t/U5VTICdmz1rupDAeHnJW9c8/m2LMU7wlgHYQ9C1WnBtdWITjdcZJVhFI= Received: by 10.66.242.20 with SMTP id p20mr4246237ugh; Mon, 24 Jul 2006 21:09:30 -0700 (PDT) Received: by 10.67.97.10 with HTTP; Mon, 24 Jul 2006 21:09:30 -0700 (PDT) Message-ID: <224f32340607242109p4570ab50u536266a8d005d63d@mail.gmail.com> Date: Mon, 24 Jul 2006 21:09:30 -0700 From: "Thomas Dudziak" To: ddlutils-user@db.apache.org Subject: Re: Can't drop unique index on SQL Server. In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N On 7/24/06, Jun Li 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