Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the different type of normalization? : Sql dba

968


How can get second highest salary in sql?

907


What is pivot query?

1013


What is sql partition function?

1113


how to drop an existing view in mysql? : Sql dba

994


Does pl sql work in mysql?

918


What is a primary key sql?

989


Is vs as in pl sql?

929


What are different types of queries in sql?

1043


What are pl sql data types?

949


What is the difference between clustered and non-clustered index in sql?

953


What is embedded sql what are its advantages?

958


What is dynamic query?

909


Which nosql database is best?

915


What is the benefit of foreign key?

959