srowen commented on a change in pull request #25590: [SPARK-28791] [DOC]
Documentation for Alter table Command
URL: https://github.com/apache/spark/pull/25590#discussion_r337178455
##########
File path: docs/sql-ref-syntax-ddl-alter-table.md
##########
@@ -19,4 +19,239 @@ license: |
limitations under the License.
---
-**This page is under construction**
+### Description
+`ALTER TABLE` statement changes the schema or properties of a table.
+
+### RENAME
+`ALTER TABLE RENAME` statement changes the table name of an exsisting table in
the Database.
+#### Syntax
+{% highlight sql %}
+ALTER TABLE [db_name.]old_table_name RENAME TO [db_name.]new_table_name
+
+ALTER TABLE table_name PARTITION partition_spec RENAME TO PARTITION
partition_spec;
+
+{% endhighlight %}
+
+#### Parameters
+<dl>
+ <dt><code><em>old_table_name</em></code></dt>
+ <dd>Name of an existing table.</dd>
+</dl>
+<dl>
+ <dt><code><em>db_name</em></code></dt>
+ <dd>Name of the exsisting database.</dd>
+</dl>
+
+<dl>
+ <dt><code><em>new_table_name</em></code></dt>
+ <dd>New name using which the table has to be renamed.</dd>
+</dl>
+
+<dl>
+ <dt><code><em>partition_spec</em></code></dt>
+ <dd>Partition to be renamed.</dd>
+</dl>
+
+
+### ADD COLUMNS
+`ALTER TABLE ADD COLUMNS` statement adds mentioned columns to an exsisting
table.
+
+#### Syntax
+{% highlight sql %}
+ALTER TABLE table_name ADD COLUMNS (col_spec[, col_spec ...])
+{% endhighlight %}
+
+#### Parameters
+<dl>
+ <dt><code><em>table_name</em></code></dt>
+ <dd>The name of an existing table.</dd>
+</dl>
+
+
+<dl>
+ <dt><code><em>COLUMNS (col_spec)</em></code></dt>
+ <dd>Specifies the columns to be added to be renamed.</dd>
+</dl>
+
+
+### SET AND UNSET
+
+#### SET TABLE PROPERTIES
+`ALTER TABLE SET` command is used for setting the Table properties.If a
particular property was already set,
+this overrides the old value with the new one.
+
+`ALTER TABLE USET` is used to drop the table Property.
Review comment:
`UNSET`
Property -> property
----------------------------------------------------------------
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]
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
