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
...
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