ALTER DATABASE SET DBPROPERTIES

Kebijakan Privasi

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

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

-- Alters the database to set properties `author`.

ALTER DATABASE product SET DBPROPERTIES ('author' = 'allen');