|
1878.5.4
by Brian Aker
Update documentation. |
1 |
ALTER SCHEMA
|
2 |
============
|
|
|
1945.3.8
by Marisa Plumb
fixes to some rst markup |
3 |
|
4 |
ALTER SCHEMA changes the definition of a schema. |
|
5 |
||
|
2222.2.1
by Mark Atwood
documentation work |
6 |
You must own the schema to use ALTER SCHEMA. To rename a schema you |
7 |
must also have the CREATE privilege for the database. To alter the |
|
8 |
owner, you must also be a direct or indirect member of the new owning |
|
9 |
role, and you must have the CREATE privilege for the database: |
|
|
2165.2.5
by Andrew Hutchings
Make fixes to temporal docs |
10 |
|
11 |
.. code-block:: mysql |
|
|
1945.3.8
by Marisa Plumb
fixes to some rst markup |
12 |
|
13 |
ALTER SCHEMA name RENAME TO new_name |
|
14 |
ALTER SCHEMA name OWNER TO new_owner |
|
15 |
||
16 |
name |
|
17 |
||
18 |
The name of an existing schema. |
|
19 |
||
20 |
new_name |
|
21 |
||
|
2222.2.1
by Mark Atwood
documentation work |
22 |
The new name of the schema. |
|
1945.3.8
by Marisa Plumb
fixes to some rst markup |
23 |
|
24 |
new_owner |
|
25 |
||
26 |
The new owner of the schema. |
|
27 |
||
28 |
||
|
2165.2.5
by Andrew Hutchings
Make fixes to temporal docs |
29 |
.. seealso:: |
|
1945.3.8
by Marisa Plumb
fixes to some rst markup |
30 |
|
|
2165.2.5
by Andrew Hutchings
Make fixes to temporal docs |
31 |
:doc:`create_schema` and :doc:`drop_schema` |