OraFAQ Forum: SQL & PL/SQL » Drop ... Cascade Constraints

Home » SQL & PL/SQL » SQL & PL/SQL » Drop ... Cascade Constraints (10g RHEL5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Drop ... Cascade Constraints [message #343505]

Wed, 27 August 2008 07:50

marcossantos
Messages: 123
Registered: June 2008

Senior Member

Hi,

I need drop some tables of the schema in database.

There are dependencies in this tables. There area tables of other schemas referring this table.

I need to keep this dependencies and recreate this table;

How can I do?

Marcos Santos

Report message to a moderator

Re: Drop ... Cascade Constraints [message #343510 is a reply to message #343505]

Wed, 27 August 2008 07:55

tyler_durden
Messages: 14
Registered: August 2008
Location: http://tinyurl.com/63fmwx

Junior Member

Quote:

I need to keep this dependencies and recreate this table;

You cannot. If you want to recreate the parent table, then you will have to:

- drop the foreign key constraint(s)
- drop the parent table
- create the parent table
- create the foreign key constraint(s)

HTH
tyler_durden

Report message to a moderator

Re: Drop ... Cascade Constraints [message #343513 is a reply to message #343505]

Wed, 27 August 2008 07:58

nagarajumail
Messages: 1
Registered: November 2007

Junior Member

firs u find out which table containing primay key.
You can use this query remove the primary relationship

alter table table_name drop primary key

regards

Report message to a moderator