Delete Cascade question

SRID SRName TerID
1      joe   E
2      sue   E
3      Meg   C

TerID   TerName
E        East
W        west
C        Central

Would deleting the first row in the first table (1,Joe, E) delete the second row (2,Sue,E) and the first row in the second table (E, East)?