1 files changed, 27 insertions, 0 deletions
diff --git a/src/bin/pgaccess/lib/help/create_view.hlp b/src/bin/pgaccess/lib/help/create_view.hlp
new file mode 100644
index 00000000000..416807e62bf
--- /dev/null
+++ b/src/bin/pgaccess/lib/help/create_view.hlp
@@ -0,0 +1,27 @@
+.pgaw:Help.f.t insert end "CREATE VIEW" {bold} " will define a view of a table. This view is not physically materialized. Specifically, a query rewrite retrieve rule is automatically generated to support retrieve operations on \
+views. 
+
+" {} "Synopsis" {bold} "
+
+CREATE VIEW view
+    AS SELECT query
+
+" {} "Usage" {bold} "
+
+Create a view consisting of all Comedy films: 
+" {} "
+CREATE VIEW kinds AS
+    SELECT *
+    FROM films
+    WHERE kind = 'Comedy';
+
+SELECT * FROM kinds;
+
+code |title                    |did| date_prod|kind      |len
+-----+-------------------------+---+----------+----------+------
+UA502|Bananas                  |105|1971-07-13|Comedy    | 01:22
+C_701|There's a Girl in my Soup|107|1970-06-11|Comedy    | 01:36
+
+" {code} "Notes" {bold} "
+
+Use the DROP VIEW statement to drop views. "