Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Want to delete rows

Author  Topic 

sandesh_moghe
Constraint Violating Yak Guru

310 Posts

Posted - 2001-08-30 : 07:40:25
Hi,
I have to tables, first is the Header table and second is Details table.
Header information is stored in Header table, and multiple details of a header is stored in Details table.
Now when i delete all the lines regarding a header then automatically header should be deleted from Header table (Trigger)
How is it possible?

Thanx in advance

-----------------------
Sandesh - The Messanger

Edited by - sandesh_moghe on 08/30/2001 07:51:50
   

- Advertisement -