alter table drop constraint drop index

View All Scripts Login to Run Script

Script Name alter table drop constraint drop index
Description Demonstrates the syntax `alter table foo drop constraint un_foo drop index;` works. Why?
Area SQL General / DDL
Contributor recursive CTE with cross join
Created Monday November 13, 2017

Statement 1

create table foo (id varchar(26) not null, name varchar(50) not null)

Table created.

Statement 2

alter table foo add constraint pk_foo primary key (id)

Table altered.

Statement 3

create unique index un_foo on foo (name)

Index created.

Statement 4

alter table foo add constraint un_foo unique (name)

Table altered.

Statement 5

alter table foo drop constraint un_foo drop index

Table altered.

Additional Information