Delete + Sql server

Hello,

Three tables are there A, B, C. In table A the primary key id ‘AId’ which is forigen key in the other two tables.
I want that if I delete 1 row from table A the corresponding rows from tables B & C should be automatically deleted.
Got it or not?

If anybody has answer then please do help

Thanks