LucidDbCreateView

Syntax

CREATE VIEW qualified-view-name
[ ( unqualified-column-name, ... ) ]
[ DESCRIPTION view-description ]
AS query-expression

For query-expression, see LucidDbSqlReference#Queries

Example

CREATE VIEW emp_view 
DESCRIPTION 'Extraction view for employees and their departments'
AS
SELECT e.empno, e.ename, d.dname, e.job
FROM extraction_schema.emp e INNER JOIN extraction_schema.dept d
ON e.deptno=d.deptno;