Oracle

[Raistlin]

There is a bunch of constraints on my table.
I want to drop them but I can't find anywhere the syntax to drop a constraint without delete the table or its information.

Raistlin

[GungaDin]

Not really a VB question but the syntax is:

ALTER TABLE TableName
DROP CONSTRAINT ConstraintName CASCADE;

CASCADE is optional I think but if the changes are cascading and you don't have it you will get an error.

Is your name really Raistlin? If so, your parents must have loved the Dragonlance books :)

Hope this helps,

Nathan Liebke (Yes that's my real name)

[Raistlin]

Thank you
I know it wasn't a VB question but I come here a lot and answer many peoples questions that deal with Oracle and DB connections. I thank you for the help.


The Black Robe Concave
Master of Past and present(Raistlin)