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?

RenDC

» Interview Questions and Answers » Questions » News Feed » Tutorials » rendc.com

Question and Answer:

Home Database Administrator (DBA)

⟩ 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?

Disable the foreign key constraint to the parent, drop the table, re-create the table, enable the foreign key constraint.

Is this answer helpful?
0 Yes | 0 No

153 views

More Questions for you:

Is it possible to disable the parameter from while running the report?

Can a property clause itself be based on a property clause?

What is a timer?

What is term?

What is the maximum no of chars the parameter can store?

What is a text list?

What is pop list?

What is use of term?

What is an index and How it is implemented in Oracle database?

What are the default extensions of the files created by library module?

rendc.org

Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."

Quick Links:

Interview Question and Answer Questions Add Questions News-Feed Add Posts HR Hacks Tutorials Profile rendc.com memeph.com

Question and Answer:

Home Database Administrator (DBA)

⟩ 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?

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

Quick Links:

Question and Answer:

Home Database Administrator (DBA)

⟩ 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?

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

BE THE FIRST TO KNOW

Quick Links: