CREATE VIEW
Description
Creates a new view in the current database. You define a list of columns, which each hold data of a distinct type. The owner of the view is the issuer of the CREATE VIEW command.
For more information, please refer to CREATE VIEW
documentation.
Grammar Syntax
CREATE [ OR REPLACE ] VIEW
… [ owner.]view-name [ ( column-name [ , … ] ) ]
… AS select-without-order-by
… [ WITH CHECK OPTION ]
Sample Source Patterns
Input Code:
CREATE OR REPLACE VIEW VIEW1
AS
SELECT
COL1, COL2
FROM T1
WITH CHECK OPTION;
Output Code:
CREATE OR REPLACE VIEW VIEW1
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": { "major": 0, "minor": 0, "patch": "0" }, "attributes": { "component": "sybase", "convertedOn": "04/15/2025", "domain": "test" }}'
AS
SELECT
COL1,
COL2
FROM
T1;
Last updated