# CTE Resource Center - Verso - Database Design and Management (Oracle) Task 1685818598

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Write SQL code to alter the definition of a view.

Definition

Altering a definition of a view should include the following syntax:

CREATE OR REPLACE VIEW [name]
(column, column, column)
AS SELECT column, column, column
FROM  [table_name]
WHERE  condition to create a view

Related Standards of Learning

Mathematics

COM.1

The student will design and apply computer programs to solve practical problems in mathematics arising from business and applications in mathematics.

COM.3

The student will write program specifications that define the constraints of a given problem.