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
- 15043 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is an Oracle database Full Backup?
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
what are the API of GL,PO,AP
can we use lexical perameter in oracle plsql if yes how
what is difference between inner join & nested query or subqueries
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
What is mrc and what is its use? : oracle accounts receivable
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
can u give guidance abt packages of plsql
What is supporting issues GL AP and AR?
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
Difference between negative and positive adjustments : oracle accounts receivable
Explain how to close periods in ar. : oracle accounts receivable
