Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
112 views
in Technique[技术] by (71.8m points)

sql - On Delete Cascade method

Hello I would like to use method ON DELETE CASCADE I have found schema, but it doesn't work in my program.

SELECT table_name FROM referential_constraints  
WHERE constraint_schema = 'employeedb'  
        AND referenced_table_name = 'Employee'  
        AND delete_rule = 'CASCADE';  
SELECT *
FROM Worker
WHERE Born > '1950'
        AND referenced_table_name = 'Meetings'  
        AND delete_rule = 'CASCADE';   

Using SQLDeveloper

question from:https://stackoverflow.com/questions/65911151/on-delete-cascade-method

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
Waitting for answers

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...