yutoacts commented on a change in pull request #35239:
URL: https://github.com/apache/spark/pull/35239#discussion_r793553705



##########
File path: docs/sql-ref-syntax-ddl-alter-table.md
##########
@@ -75,6 +75,50 @@ ALTER TABLE table_identifier ADD COLUMNS ( col_spec [ , ... 
] )
 
     Specifies the columns to be added.
 
+### DROP COLUMNS
+
+`ALTER TABLE DROP COLUMNS` statement drops mentioned columns from an existing 
table.
+Note that this statement is only supported with v2 tables.
+
+
+#### Syntax
+
+```sql
+ALTER TABLE table_identifier DROP COLUMNS ( col_name1, ... )
+```

Review comment:
       It seems that `col_spec` is only used in this doc (for ADD COLUMN, 
RENAME COLUMN and ALTER/CHANGE COLUMN), and I agree with you that `col_spec` 
sounds misleading when only a name of a column is needed. I'll change all 
`col_spec` in `col_name` except ones in ADD COLUMN (since ADD COLUMN needs data 
type as well).




-- 
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.

To unsubscribe, e-mail: [email protected]

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



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to