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
