home *** CD-ROM | disk | FTP | other *** search
/ CD Actual Thematic 7: Programming / CDAT7.iso / demos / vj / common / ide / ide98 / Tmplts / DBItem / newtrigg.sql < prev    next >
Encoding:
Text File  |  1998-04-24  |  890 b   |  35 lines
  1. IF EXISTS (SELECT * FROM sysobjects WHERE type = 'TR' AND name = 'Trigger_Name')
  2.     BEGIN
  3.         PRINT 'Dropping Trigger Trigger_Name'
  4.         DROP  Trigger Trigger_Name
  5.     END
  6. GO
  7.  
  8. /******************************************************************************
  9. **        File: 
  10. **        Name: Trigger_Name
  11. **        Desc: 
  12. **
  13. **        This template can be customized:
  14. **              
  15. **
  16. **        Auth: 
  17. **        Date: 
  18. *******************************************************************************
  19. **        Change History
  20. *******************************************************************************
  21. **        Date:        Author:                Description:
  22. **        --------        --------                -------------------------------------------
  23. **    
  24. *******************************************************************************/
  25.  
  26. PRINT 'Creating Trigger Trigger_Name'
  27. GO
  28. CREATE Trigger Trigger_Name 
  29.  
  30.    
  31.     /*INSERT_TRIGGER_STATEMENT*/
  32.  
  33. GO
  34.  
  35.