I am working in vb and C# .net as front hand and use mySql or Squel server as back-hand.
task is, i did here it that, we have more than one table, each and every is related by using the concept of Primary and Foreign key management.
in that database if i remove a record from master table, than the related record of all child talbes shall auto-matically reoved that is my question how it does happen.
first thing that you have understood my problem if yes than please if you have any idea, mail me.
i will very much thnks in advance to you.
bye
regards Rajat.Moving to more appropriate forum.|||
In SQL Server you can either implement tzhis using your own logic by triggers or you use the built in automatically working functonality whic is called cascading delete. See more information about this in the Online help of SQL Server:
http://msdn2.microsoft.com/en-us/library/ms186973.aspx
Jens K. Suessmeyer.
-
http://www.sqlserver2005.de
-
No comments:
Post a Comment