write a query to delete similar records in particular
fields(columns) in different tables

Answer Posted / ram

Guys, Please see the question again. It is related to
deleting different tables. I guess, the question is
intented to get the answer - ON DELETE CASCADE. We give
foreign constraints on tables and when the parent record is
deleted, the child records are automatically deleted when
you give command as ON DELETE CASCADE

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql comments?

653


What is mutating error in pl sql?

553


Are subqueries better than joins?

536


How can we make an if statement within a select statement?

543


what is the difference between nested subquery and correlated subquery?

550






Do foreign keys improve performance?

549


Can we insert data into view?

527


what is commit? : Sql dba

619


What can sql server reporting services do?

586


What are the different types of constraints?

566


What is mdb stand for?

558


What kind of join is join?

559


Is sql the best database?

503


Why do we use procedures in sql?

551


Can we commit inside a trigger?

550