ALTER DATABASE DESCRIPTION
Syntax
Parameters
Parameter | Description |
---|---|
<database_name> | The name of the database to be altered. |
<description> | The description of the database. |
Example
The following example alters a description of the database:ALTER DATABASE RENAME TO
Renames the specified database.Syntax
Parameters
Parameter | Description |
---|---|
<database_name> | The name of the database to rename. |
<new_database_name> | The new name of the database. |
If the renamed database is set as
DEFAULT_DATABASE
for any engine, queries on that engine will fail unless a different database is specified or selected. You can change the default database for an engine using the ALTER ENGINE
command.ALTER DATABASE OWNER TO
Change the owner of a database. The current owner of a database can be viewed in the information_schema.catalogs view oncatalog_owner
column.
check ownership page for more info.
Syntax
Parameters
Parameter | Description |
---|---|
<database_name> | The name of the database to change the owner of. |
<user> | The new owner of the database. |