How to add ‘ON DELETE CASCADE’ in ALTER TABLE statement

by

You can not add ON DELETE CASCADE to an already existing constraint. You will have to drop and re-create the constraint. The documentation shows that the MODIFY CONSTRAINT clause can only modify the state of a constraint (i-e: ENABLED/DISABLED…).

More Related Contents:

  1. How do I limit the number of rows returned by an Oracle query after ordering?
  2. How to create id with AUTO_INCREMENT on Oracle?
  3. When do I need to use a semicolon vs a slash in Oracle SQL?
  4. Is there an Oracle SQL query that aggregates multiple rows into one row? [duplicate]
  5. How to handle a single quote in Oracle SQL
  6. Select count(*) from multiple tables
  7. Fetch the rows which have the Max value for a column for each distinct value of another column
  8. REGEX to select nth value from a list, allowing for nulls
  9. SQL – How to select a row having a column with max value [duplicate]
  10. create table with sequence.nextval in oracle [duplicate]
  11. Oracle: loading a large xml file?
  12. IF EXISTS condition not working with PLSQL
  13. Group by alias (Oracle)
  14. Using pivot on multiple columns of an Oracle row
  15. Sleep function in ORACLE
  16. Solution to “cannot perform a DML operation inside a query”?
  17. Split comma separated values of a column in row, through Oracle SQL query
  18. oracle — Split multiple comma separated values in oracle table to multiple rows
  19. How to query a CLOB column in Oracle
  20. update columns values with column of another table based on condition [duplicate]
  21. how to select even records from a table in oracle?
  22. How do I list all tables in a schema in Oracle SQL?
  23. Is there a version control system for database structure changes?
  24. oracle sql: update if exists else insert [duplicate]
  25. Oracle: Updating a table column using ROWNUM in conjunction with ORDER BY clause
  26. Return number from Oracle Select statement after parsing date
  27. How do you interpret a query’s explain plan?
  28. How to call Oracle MD5 hash function?
  29. SQL Server equivalent of WM_CONCAT function [duplicate]
  30. Oracle: ‘= ANY()’ vs. ‘IN ()’

Leave a Comment