How to Alter Constraint

by

You can not alter constraints ever but you can drop them and then recreate.

Have look on this

ALTER TABLE your_table DROP CONSTRAINT ACTIVEPROG_FKEY1;

and then recreate it with ON DELETE CASCADE like this

ALTER TABLE your_table
add CONSTRAINT ACTIVEPROG_FKEY1 FOREIGN KEY(ActiveProgCode) REFERENCES PROGRAM(ActiveProgCode)
    ON DELETE CASCADE;

hope this help

More Related Contents:

  1. SQL Query output in VBA is different than in SQL Oracle
  2. I want to find out how much zero come after 1 in SQL
  3. Update statement with inner join on Oracle
  4. Splitting string into multiple rows in Oracle
  5. Is there any function in oracle similar to group_concat in mysql? [duplicate]
  6. How to use the ‘as’ keyword to alias a table in Oracle?
  7. What is the string concatenation operator in Oracle?
  8. Using an Alias in a WHERE clause
  9. How can I introduce multiple conditions in LIKE operator?
  10. Is there any boolean type in Oracle databases?
  11. Stored Procedure with optional “WHERE” parameters
  12. subquery in FROM must have an alias
  13. SQL (ORACLE): ORDER BY and LIMIT [duplicate]
  14. Dynamic Oracle Pivot_In_Clause
  15. Convert Unixtime to Datetime SQL (Oracle)
  16. What is the equivalent PostgreSQL syntax to Oracle’s CONNECT BY … START WITH?
  17. Selecting the second row of a table using rownum
  18. sqlplus statement from command line
  19. How to debug ORA-01775: looping chain of synonyms?
  20. Does Oracle store trailing zeroes for Number data type?
  21. Deferrable Constraints in SQL Server
  22. Nth max salary in Oracle
  23. What does the colon sign “:” do in a SQL query?
  24. How do I get textual contents from BLOB in Oracle SQL
  25. SQL not displaying null values on a not equals query?
  26. Oracle query to match all values in the list among all rows in table
  27. Inserting into Oracle and retrieving the generated sequence ID
  28. How can I solve ORA-00911: invalid character error?
  29. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  30. Exporting a CLOB to a text file using Oracle SQL Developer

Leave a Comment