Home » RDBMS Server » Server Administration » Drop Master Detail Table
Drop Master Detail Table [message #312385] Tue, 08 April 2008 13:42 Go to next message
ORAGENASHOK
Messages: 238
Registered: June 2006
Location: Chennai
Senior Member
I have created one master table and a detail table which references the primary column of the master table.

Now i dropped the master table then i want to drop the detail table is it possible?

I tried but it gives error an
A-02449: unique/primary keys in table referenced by foreign keys

How can i rectify this by not create master table again
Re: Drop Master Detail Table [message #312386 is a reply to message #312385] Tue, 08 April 2008 13:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64110
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Your detail table is a master for another one.

Regards
Michel

[Updated on: Tue, 08 April 2008 13:45]

Report message to a moderator

Re: Drop Master Detail Table [message #312388 is a reply to message #312386] Tue, 08 April 2008 13:48 Go to previous messageGo to next message
ORAGENASHOK
Messages: 238
Registered: June 2006
Location: Chennai
Senior Member
Thanks Michel
Re: Drop Master Detail Table [message #312390 is a reply to message #312385] Tue, 08 April 2008 13:51 Go to previous messageGo to next message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
ORAGENASHOK,

why do you refuse to follow posting guidelines?

[Updated on: Tue, 08 April 2008 13:51] by Moderator

Report message to a moderator

Re: Drop Master Detail Table [message #312548 is a reply to message #312390] Wed, 09 April 2008 03:59 Go to previous messageGo to next message
ORAGENASHOK
Messages: 238
Registered: June 2006
Location: Chennai
Senior Member
No
Re: Drop Master Detail Table [message #312559 is a reply to message #312548] Wed, 09 April 2008 04:35 Go to previous message
Michel Cadot
Messages: 64110
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No? ./fa/1600/0/ No for what?

Regards
Michel
Previous Topic: startup mount
Next Topic: csscan report advice
Goto Forum:
  


Current Time: Mon Dec 05 11:11:54 CST 2016

Total time taken to generate the page: 0.09971 seconds