Updated on 2024-10-09 GMT+08:00

SET

Function

The ALTER TABLE ... SET|UNSET command is used to modify table properties.

Syntax

ALTER TABLE Table name SET|UNSET tblproperties

Parameter Description

Table 1 SET|UNSET parameters

Parameter

Description

tableName

Table name.

tblproperties

Table properties.

Example

ALTER TABLE table SET TBLPROPERTIES ('table_property' = 'property_value')
ALTER TABLE table UNSET TBLPROPERTIES [IF EXISTS] ('comment', 'key')

Response

You can run the DESCRIBE command to view new table properties.