|
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 |
||
|
2165.2.5
by Andrew Hutchings
Make fixes to temporal docs |
6 |
You must own the schema to use ALTER SCHEMA. To rename a schema you must also have the CREATE privilege for the database. To alter the owner, you must also be a direct or indirect member of the new owning role, and you must have the CREATE privilege for the database: |
7 |
||
8 |
.. code-block:: mysql |
|
|
1945.3.8
by Marisa Plumb
fixes to some rst markup |
9 |
|
10 |
ALTER SCHEMA name RENAME TO new_name |
|
11 |
ALTER SCHEMA name OWNER TO new_owner |
|
12 |
||
13 |
name |
|
14 |
||
15 |
The name of an existing schema. |
|
16 |
||
17 |
new_name |
|
18 |
||
|
1994.4.20
by Marisa Plumb
fixed build warnings |
19 |
The new name of the schema. The new name cannot begin with "pg", as such names are reserved for system schemas. |
|
1945.3.8
by Marisa Plumb
fixes to some rst markup |
20 |
|
21 |
new_owner |
|
22 |
||
23 |
The new owner of the schema. |
|
24 |
||
25 |
||
|
2165.2.5
by Andrew Hutchings
Make fixes to temporal docs |
26 |
.. seealso:: |
|
1945.3.8
by Marisa Plumb
fixes to some rst markup |
27 |
|
|
2165.2.5
by Andrew Hutchings
Make fixes to temporal docs |
28 |
:doc:`create_schema` and :doc:`drop_schema` |