CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition
		

update view

SQL CREATE OR REPLACE VIEW Syntax
CREATE OR REPLACE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition