1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
|
# SQL definition for views
# CAUTION: Do not modify this file unless you know what you are doing.
# Code generation can be broken if incorrect changes are made.
@include "ddlend"
@include "objlabel"
@include "prependedsql"
%if {materialized} %then
[CREATE ]
%else
[CREATE OR REPLACE ]
%end
%if {recursive} %then
[RECURSIVE ]
%else
%if {materialized} %then
[MATERIALIZED ]
%end
%end
VIEW $sp {name}
%if {columns} %then
[ (] {columns} [)]
%end
%if {materialized} %and {tablespace} %then
$br TABLESPACE $sp {tablespace}
%end
%if {options} %then
$br [WITH (] {options} [)]
%end
$br [AS ] $br {definition}
%if {materialized} %and {with-no-data} %then
$br [WITH NO DATA]
%end
%if %not {materialized} %and {check-option} %then
$br [WITH ] {check-option} [ OPTION]
%end
[;]
@include "footer"
|
