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 is int identity in sql?

1113


How do you optimize a query?

974


What is rename command in sql?

1002


What are the different type of joins in sql?

934


what is the use of friend function? : Sql dba

1009


What is db journal file?

1034


Can we join two tables without common column?

985


Can we join same table in sql?

997


Does pl/sql support create command?

1086


What is the purpose of my sql?

937


What is mutating table error?

1155


What is pl sql variable?

962


What are records give examples?

990


What type of join is sql join?

962


What is the most restrictive isolation level? : Transact sql

1068