Plantilla para crear una Vista en SQL Server



IF EXISTS (SELECT *
           FROM INFORMATION_SCHEMA.VIEWS
           WHERE TABLE_NAME='vXXXXX'
           AND TABLE_SCHEMA='dbo'
          )
          DROP VIEW dbo.vXXXXX
GO

CREATE VIEW dbo.vXXXXX
AS
/*@@*_____________________________________________________________________

  (c) 2013 XXXXX

  Object:  dbo.vXXXXX
  Author:  ...
  Created: ...

  Purpose:

    ...
    ...
    ...


  Revision History:
    Author dd-mmm-yyyy Purpose

_____________________________________________________________________*@@*/


  SELECT
    ...
  FROM
    ...


No hay comentarios:

Publicar un comentario