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
How do I find duplicates in a single column in sql?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
What are the types of sql commands?
what are the different functions in sorting an array? : Sql dba
Mention what is the plv (pl/vision) package offers?
How can we make an if statement within a select statement?
How many primary keys can a table have?
what is the difference between truncate and drop statements? : Sql dba
What are sql ddl commands?
Explain locks? : Transact sql
what is online transaction processing (oltp)? : Sql dba
What is a primary key sql?
What pl/sql package consists of?
how to drop an existing index in mysql? : Sql dba
Is sql a backend language?