Alter Database
Important
This documentation has been retired and might not be updated. The products, services, or technologies mentioned in this content are no longer supported. See ALTER DATABASE.
ALTER [DATABASE|SCHEMA] db_name SET DBPROPERTIES (key=val, ...)
SET DBPROPERTIES
Specify a property named key
for the database and establish the value for the property respectively as val
. If key
already exists, the old value is overwritten with val
.