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
Why are indexes and views important to an organization?
What is multiple partition?
Explain what is a view?
Can a table have no primary key?
What does select count (*) mean in sql?
Are subqueries better than joins?
Why query optimization is needed?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
Can we create foreign key without primary key?
What is the example of procedure?
What is the difference between the sql*loader and import utilities? : aql loader
Can a foreign key have a different name?
Why does sql need a server?
Can function return multiple values in sql?
What is vector point function?