ALTER TABLE SET TBLPROPERTIES

Adds custom metadata properties to a table sets their assigned values.

Synopsis#

ALTER TABLE table_name SET TBLPROPERTIES ('property_name' = 'property_value' [ , ... ])

Parameters#

SET TBLPROPERTIES ('property_name' = 'property_value' [ , ... ])
Specifies the metadata properties to add as 'property_name' and the value for each as 'property value`''.  If ``property_name already exists, its value is reset to property_value.

Note

Managed tables are not supported, so setting 'EXTERNAL'='FALSE' has no effect.

Examples#

ALTER TABLE orders SET TBLPROPERTIES ('notes'="Please don't drop this table.");