Help Center/ MapReduce Service/ Component Operation Guide (LTS) (Ankara Region)/ Using Hudi/ Hudi SQL Syntax Reference/ DDL/ ALTER ALTER COLUMN
Updated on 2024-11-29 GMT+08:00
View PDF
Share

ALTER ALTER COLUMN

Function

This command is used to change the default values of a column.

Syntax

ALTER TABLE tableIdentifier ALTER COLUMN colName SET DEFAULT defaultValue

Parameter Description

Table 1 ADD COLUMNS parameters

Parameter

Description

tableIdentifier

Table name

colName

Column name

defaultValue

Default value of a column

Example

alter table h0_1 alter column extl set default 'new_default_value';

System Response

You can view query results on the client.

Parent topic: DDL