Writing a foreign key constraint query

Published by: Riya (3/2/2009 4:54:14 PM)

I have 2 tables and I don’t want the user to delete from table 1 when the related records are already there in table 2. Is there a query that you can help me to write that will make sure for available records from table 2 before deleting a record from table 1? Thank you..

 

Most Popular Articles

• How can I run my Stored Procedure in SQL Server 2005
• SQL Join Query for Microsoft Access Database
• What is the use of nolock condition in SQL Query
• How can I Truncate my Database Log to Reduce the Size
• when to use cast and when to use convert operator in SQL

How Can I Schedule One Event in MySQL Database >>

<< Can I Concatenate String from a Column and Get Back One Row