Alter table to add/update multiple column comments
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-24-2024 11:06 AM
I was wondering if there's a way to alter table and add/update comments for multiple columns at once using SQL or API calls. For instance -
ALTER TABLE <table_name> CHANGE COLUMN <col1> COMMENT '<comment1>',
CHANGE COLUMN <col2> COMMENT 'comment2' ;
I would like to update column comments for multiple tables for over 200 fields and flexible using sql, pyspark, apis. Would be great if there is a way to achieve this. Thanks in advance...
