-
How to modify an existing table constraint
Hai All,
It's possible to modify an existing table constraint -
----for example, to add "ON DELETE CASCADE" to an existing foreign key
constraint?
With regards
Bala Krishna
-
Hi.
The syntax diagram for 9i does not give an option to modify this clause of a ref constraint. Looks like you have to drop and recreate it.
See: http://download-west.oracle.com/docs...2a.htm#2081099
Cheers
Tim...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|