| cascade [message #4450] |
Tue, 10 December 2002 22:03  |
Karthik
Messages: 63
Registered: February 2000
|
Member |
|
|
What is the exact functionality of a cascade operator?.
What does this command do?
"Drop Table Consultant Ref CASCADE CONSTRAINTS;"
|
|
|
|
| Re: cascade [message #4451 is a reply to message #4450] |
Wed, 11 December 2002 00:21  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
This will drop all foreign key constraints referring to your table too. If the table name is 'CONSULTANT' than you should know that the "Ref" part is not a keyword. The command is: "DROP TABLE your_table" or "DROP TABLE your_table CASCADE CONSTRAINTS". The Oracle Online Documentation (otn.oracle.com/documentation) can provide more info.
MHE
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
