home *** CD-ROM | disk | FTP | other *** search
/ CD Actual Thematic 7: Programming / CDAT7.iso / demos / vj / common / ide / ide98 / Tmplts / DBItem / newview.sql < prev   
Encoding:
Text File  |  1998-04-24  |  903 b   |  40 lines
  1. IF EXISTS (SELECT * FROM sysobjects WHERE type = 'V' AND name = 'View_Name')
  2.     BEGIN
  3.         PRINT 'Dropping View View_Name'
  4.         DROP  View View_Name
  5.     END
  6. GO
  7.  
  8. /******************************************************************************
  9. **        File: 
  10. **        Name: View_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 View View_Name'
  27. GO
  28. CREATE View View_Name
  29. as
  30.  
  31.     /*INSERT_SELECT_STATEMENT*/
  32.  
  33.  
  34. GO
  35.  
  36.  
  37. GRANT SELECT ON View_Name TO PUBLIC
  38.  
  39. GO
  40.