Teradata - REPLACE VIEW - Create or Replace View

REPLACE VIEW statement creates a new view, or re-creates the existing view in Teradata.

Quick Example:

Create a new view. If the view already exists, it will be replaced with the new definition:

   REPLACE VIEW sales_by_state
    AS SELECT state, SUM(amount) FROM sales GROUP BY state;

REPLACE VIEW Overview

Summary information:

Syntax (simplified)	REPLACE VIEW view_name AS select_clause
Alternatives	CREATE VIEW	Creates a new view

Last Update: Teradata 13

Creating or replacing view in other databases:

Oracle:

CREATE OR REPLACE view_name AS select_clause