ON DELETE CASCADE question

[James Sherwood]

Hello.

I have a question about on delete cascade.

If i have 2 tables such as this:

Table1                        Table2

Prikey                        Prikey
Table2foreinkey           name
name                         description
description

Now if I delete a row from table1 that has a foreign key from table 2 should it 
delete the row in table 2?


Thanks,
James