AS SELECT state, SUM (amount) FROM sales GROUP BY state; 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 statement creates a new view, or re-creates the existing view in Teradata. CREATE VIEW statement creates new view only. The use of LOCKING ROW prevents possible deadlocks occurring when two simultaneous primary index SELECTs are followed by an UPDATE, DELETE, or INSERT on the same row.

If you enter a REPLACE VIEW request for a view that does not exist, the system creates the view following the specifications in the REPLACE statement. This example shows how you can create a view on a table that is defined with row-level security constraints. First create the table emp_record.

The view is a logical table that can be referenced by future queries. Views do not contain any data. Instead, the query stored by the view is executed everytime the view is referenced by another query. The optional OR REPLACE clause causes the view to be replaced if it already exists rather than raising an error.