tencent cloud

Data Lake Compute

DocumentationData Lake ComputeSQL StatementSuperSQL StatementUnified StatementDDL StatementALTER DATABASEALTER DATABASE SET DBPROPERTIES

ALTER DATABASE SET DBPROPERTIES

Download
Focus Mode
Font Size
Last updated: 2024-08-07 17:11:15

Description

Supported engine: Presto.
Purpose: Add one or more attributes to a database. If an attribute to be added already exists, the existing one will be overwritten.

Standard Statement

ALTER (DATABASE|SCHEMA) database_name SET DBPROPERTIES (property_name=property_value, ...)

Parameter

database_name: Database name.

Example

-- Alters the database to set properties `author`.
ALTER DATABASE product SET DBPROPERTIES ('author' = 'allen');



Previous Topic: DESCRIBE DATABASENext Topic: ALTER DATABASE SET LOCATION

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback