| Subject | Dropping an unnamed constraint |
|---|---|
| Author | Tobias Grimm |
| Post date | 2007-10-04T14:47:35Z |
Hi!
When creating e.g. a UNIQUE constraint with:
ALTER TABLE PRODUCT ADD UNIQUE (NUMBER);
...without specifying a constraint name, the contstraint gets a "random"
name like "INTEG_36".
How can I query this automatically created constraint name (given the
table name, column name and constraint type), to be able to drop it?
bye,
Tobias
When creating e.g. a UNIQUE constraint with:
ALTER TABLE PRODUCT ADD UNIQUE (NUMBER);
...without specifying a constraint name, the contstraint gets a "random"
name like "INTEG_36".
How can I query this automatically created constraint name (given the
table name, column name and constraint type), to be able to drop it?
bye,
Tobias