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 are the different tables present in mysql? : Sql dba

502


How to pipe multiline string to isql?

574


What is the use of sql trace?

474


What is full join?

525


what is offset-fetch filter in tsql? : Transact sql

531






What is dense_rank in sql?

539


What is sql lookup?

511


How do I edit a trigger in sql developer?

537


Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

535


Enlist the characteristics of pl/sql?

1238


What is sql injection owasp?

546


What is sql architecture?

557


what is msql? : Sql dba

562


Does group by remove duplicates?

545


What is the most common sql injection tool?

543