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.
Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk