home *** CD-ROM | disk | FTP | other *** search
/ distrib.akp.su/Programming/Vb-6+Rus/ / distrib.akp.su.tar / distrib.akp.su / Programming / Vb-6+Rus / COMMON / IDE / IDE98 / TMPLTS / DBITEM / NEWTRIGG.SQL < prev    next >
Text File  |  1998-04-25  |  890b  |  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.