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 limitations of identity column? : Transact sql

1108


What do you mean by rowid?

979


How to move files from one directory to another in pl sql?

1196


can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

997


What is meant by temporal data?

969


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

1061


What is scalar data type in pl sql?

1070


Is t sql a programming language?

1069


What are sql procedures?

1027


What found sql?

945


What is pl sql block structure?

1037


how to use 'mysql' to run sql statements? : Sql dba

1053


What is primary and foreign key?

1064


How do I find sql profiler?

944


What are stuff and replace function?

1084