Interested to Buy Any Domain ? << Click Here >> for more details...
A table is classified as a parent table and you want to
drop and re-create it. How would you do this without
affecting the children tables?
- 3 Answers
- 14916 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shailesh donda
1. DISABLE FOREIGN KEY CONSTRAINT
2. DROP THE PARENT TABLE
3. RECREATE THE PARRENT TABLE
5. ENTER THE MEANINGFUL DATA IN PARENT TABLE
4. ENABLE FOREIGN KEY CONSTRAINT
| Is This Answer Correct ? | 29 Yes | 5 No |
Answer / hitesh
or we can also use ondelete cascade option while creating
table.using this help as to delete or change the data
easily in parent
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / sandra
drop foreign key constraint
drop parent table
recreate parent table
alter child table add foreign key
| Is This Answer Correct ? | 0 Yes | 1 No |
HOW TO SPOT AHIERARCHY?
write a query to find the third maximum salary of a employee.(table:employ col name:salary)
What is the Query Optimizer. How you optimize your qeury.
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
what is the difference between TRUNCATE and DELETE command in SQL
23 Answers ICICI, Saama Tech, SkyTech, TCS,
how can we send a concurrent program output to the clients through mail or fax give me example.
Is there any link between pr form(purchse requisition)and po form(purchase order)
i want to know about the javaBean.what is its purpose and how it can use in Forms.
Can we modify approve purchase order?if yes what is navigation?
Describe the P2P cycle ?
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
Oracle General 
