How to delete rows in associated SQL tables?

Question

I want to delete rows in GlassesColor table that associated with GlassesID in Glasses table. I want to implement this in stored procedure.The stored procedure gets only one parameter from client side , a CollectionID.

Here are the following tables:

Here is example of tables content:

Any idea how can i implement this? Thank you in advance!

Answer 1

Manually deleting would be something like this:

delete 
from GlassesColor 
where GlassesID in (select GlassesID from Glasses where CollectionID = 3)

However, unless this is a one time cleanup, you should start specifying foreign key cascading rules, like the other answers already suggested.