ALTER DATABASE SET DBPROPERTIES
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');
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback