godfreyhe commented on a change in pull request #12502:
URL: https://github.com/apache/flink/pull/12502#discussion_r436439900



##########
File path: docs/dev/table/sql/queries.zh.md
##########
@@ -313,9 +313,29 @@ SHOW DATABASES;
     <p>显示当前数据库、Catalog中的所有表</p>
 {% highlight sql %}
 SHOW TABLES;
+{% endhighlight %}
+        <p>显示当前数据库、Catalog中的所有视图</p>
+{% highlight sql %}
+SHOW VIEWS;
 {% endhighlight %}
       </td>
     </tr>
+    <tr>
+      <td>
+        <strong>Describe</strong><br>
+        <span class="label label-primary">批处理</span> <span class="label 
label-primary">流处理</span>
+      </td>
+      <td>
+                       <p>描述给定表的元数据.</p>

Review comment:
       currently, only support describing table schema

##########
File path: docs/dev/table/sql/drop.md
##########
@@ -143,6 +144,22 @@ Dropping a non-empty database triggers an exception. 
Enabled by default.
 
 Dropping a non-empty database also drops all associated tables and functions.
 
+## DROP VIEW
+
+{% highlight sql %}
+DROP [TEMPORARY] VIEW  [ IF EXISTS ] view_name
+{% endhighlight %}
+
+Drop a view that has catalog and database namespaces. If the view to drop does 
not exist, an exception is thrown.
+
+**IF EXISTS**
+
+If the view does not exist, nothing happens.
+
+**TEMPORARY**

Review comment:
       move this section to the front of **IF EXISTS**

##########
File path: docs/dev/table/sql/drop.zh.md
##########
@@ -143,6 +144,22 @@ DROP DATABASE [IF EXISTS] [catalog_name.]db_name [ 
(RESTRICT | CASCADE) ]
 
 删除一个非空数据库时,把相关联的表与函数一并删除。
 
+## DROP VIEW
+
+{% highlight sql %}
+DROP [TEMPORARY] VIEW  [ IF EXISTS ] view_name
+{% endhighlight %}
+
+删除一个有 catalog 和数据库命名空间的视图。若需要删除的视图不存在,则会产生异常。
+
+**IF EXISTS**
+
+若视图不存在,则不会进行任何操作。
+
+**TEMPORARY**

Review comment:
       ditto

##########
File path: docs/dev/table/sql/queries.md
##########
@@ -313,9 +313,29 @@ SHOW DATABASES;
                <p>Show all tables in the current database in the current 
catalog</p>
 {% highlight sql %}
 SHOW TABLES;
+{% endhighlight %}
+        <p>Show all views in the current database in the current catalog</p>
+{% highlight sql %}
+SHOW VIEWS;
 {% endhighlight %}
       </td>
     </tr>
+    <tr>
+      <td>
+        <strong>Describe</strong><br>
+        <span class="label label-primary">Batch</span> <span class="label 
label-primary">Streaming</span>
+      </td>
+      <td>
+                       <p>Describe the given table.</p>

Review comment:
       explain more about `Describe` operation ? such as `Describe the schema 
of the given table.`




----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to