db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christian Rodriguez <crodrig...@gmail.com>
Subject Removing a constraint
Date Thu, 17 Mar 2005 22:39:07 GMT
Hello everyone, 

I have the following problem.

1. I created a table that has a UNIQUE constraint.

something like

create table users (
  ...
  email VARCHAR(30),
  constraint email_unq UNIQUE (email)
);

2. I drop the table and try to recreate it, but it complains that the
constraint "email_unq" already exists in schema APP.

3. Then I thought about removing the entire database by removing the
entire database directory with operating system commands.

4. I still get the same errror saying the constraint doesnt exist.

So... how do I get rid of that constraint? How do I remove all
constraints if I want to start from scratch again?

Thanks!
Xtian

Mime
View raw message