sorry if there is already a thread on this but i couldnt see one...
I just want a little bit of help about the statement ON DELETE CASADE. I am designing the structures of my tables and I am not sure about using this statement. I know it means that if a record is deleted then it will also be deleted in every table in which it is referenced by a foreign key. But, i seem to using it in every table. Should this only be used in certain tables?
Thanks in advance.