On this page

    Views (VDS)

    The SQL commands for views (also known as virtual datasets) enable you to create, replace, and drop views in your home space and other spaces.

    Creating or Replacing a View

    Syntax
    CREATE [ OR REPLACE ] VIEW <view_path> AS 
      <select_statement>
    

    Parameters

    <view_path>

    String

    The path of the view that you want to create. The name of the view should be unique. The view can be in your home space or a regular space.


    <select_statement>

    String

    The query used to populate the view.

    Examples

    Create a view
    CREATE VIEW demo.example_view_vds AS 
      SELECT * 
      FROM "oracle_tpch".DREMIO.JOBS
    
    Replace a view
    CREATE OR REPLACE VIEW demo.example_view_vds AS 
      SELECT * 
      FROM "oracle_tpch".DREMIO.INVENTORY
    

    Dropping a View

    Syntax
    DROP VIEW <view_path>
    

    Parameters

    <view_path>

    String

    The path of the view that you want to drop. The view can be in your home space or a regular space.

    Examples

    Drop a view
    DROP VIEW demo.example_view_vds