I have a tableA with primary key which acts for a foreign key for tableB. How does sql delete rows from tableB if a row is deleted form tableA, assuming ON DELETE CASCADE is on. Does SQL performs full-table scan for tableB? And what if foreign column is indexed? >Solution : The DB will perform… Read More how is cascading implemented in sql?