create_view

Creates a new database view.

Available in a network database and requires the star$define role.

Parameters:

Name	Optional	Type	Description
view$	Mandatory	Text	The name of the database view to be created.
query$	Mandatory	Text	SQL query that the view represents.

Examples:

• SELECT create_view('myview','SELECT col1 FROM mytable'); -- creates view 'myview' with one column.

Tips:

• The star$views view indicates which views already exist.