| Subject | Re: [ib-support] dropping the primary index |
|---|---|
| Author | Claudio Valderrama C. |
| Post date | 2002-01-26T06:53:32Z |
"Duilio Foschi" <dedalus@...> wrote in message
news:3.0.1.32.20020125192044.00691d38@......
rdb$relation_constraints and use ALTER TABLE syntax to drop that constant
(see LangRef).
Next time you will prefer to create named constraints in table declarations
(read LangRef, again).
C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing
news:3.0.1.32.20020125192044.00691d38@......
> is there a command by which I drop the primary index of a table ?Find the implicit constraint name in the system table
rdb$relation_constraints and use ALTER TABLE syntax to drop that constant
(see LangRef).
Next time you will prefer to create named constraints in table declarations
(read LangRef, again).
C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing