Alters an existing database.

Syntax

---

ALTER DATABASE <Name>
PATH <Path>|IN MEMORY
[ENCRYPTED CATALOG|UNENCRYPTED CATALOG]
[DESCRIPTION <Description>]
[ATTRIBUTES <CustomAttributes>]

Usage

---

Use this statement to alter an existing database. The options are the same as those for the CREATE DATABASE statement.


Examples

---

-- The following statement changes the description of the Support database.

ALTER DATABASE "Support"
PATH '\support\data'
DESCRIPTION 'Support Database for All Applications'

Required Privileges

---

The current user must be granted the system-defined Administrators role in order to execute this statement. Please see the User Security topic for more information.

SQL 2003 Standard Deviations

---

This statement deviates from the SQL 2003 standard in the following ways: