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 different tables
with same structure

Answer Posted / radha sri seshu.kolla

while creating table and giving foreign key constraint give
the key word 'on delete cascade'.automatically when the
record in the master table is delated the relaeted record
in the detail table will also be deleted.

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does t sql mean?

949


What are the different types of triggers?

1137


How you improve the performance of sql*loader? : aql loader

1014


What's the difference between inner join and left join?

1000


What is crud diagram?

949


What are schema-level triggers?

1103


Is sql database free?

979


How to assign sql query results to pl sql variables?

1082


What is an example of translating a date into julian format?

1124


what is a trigger in mysql? : Sql dba

1147


what is the difference between inner and outer join? Explain with example. : Sql dba

1026


What is pivot in sql?

916


What is the difference between count 1 and count (*) in a sql query?

997


What are the disadvantages of not performing database normalization?

1166


Is null operator in sql?

1042