Data Resource - Sql View

Undraw Environment

About

view is a data resource that represents a SQL view of a database.

Example

Operations

A sql view supports the following data operations:

and has a structure only if the select query is valid (a view can be created with an invalid query).

Data Uri

It has the same URI as any relation object such as a table 

catalog.schema.viewName@connection

Media Type

The media type for a view is sql/view or view for short against a database system



Related HowTo
Undraw Environment
How to create a SQL View with a SELECT query

This howto shows you how to create sql views with select query stored in SQL file We are going to use the tpcds query_11.sql to create this view. With the tabul create command, to create view...
Undraw Environment
How to create a SQL view with a CREATE statement file

This Howto will show you how to create a SQL View with a SQL file that contains a CREATE SQL statement with the Tabul table create command. You should have Tabulify installed on your computer: ...

Task Runner