Manpage of ALTER SCHEMA

Google
Web www.fiveanddime.net

ALTER SCHEMA

Section: SQL Commands (7)
Updated: 2003-11-02
Index Return to Main Contents
 

NAME

ALTER SCHEMA - change the definition of a schema

 

SYNOPSIS

ALTER SCHEMA name RENAME TO newname

 

DESCRIPTION

ALTER SCHEMA changes the definition of a schema. The only functionality is to rename the schema. To rename a schema you must own the schema and have the privilege CREATE for the database.  

PARAMETERS

name
Name of a schema
newname
The new name of the schema
 

COMPATIBILITY

There is no ALTER SCHEMA statement in the SQL standard.  

SEE ALSO

CREATE SCHEMA [create_schema(7)], DROP SCHEMA [drop_schema(l)]


 

Index

NAME
SYNOPSIS
DESCRIPTION
PARAMETERS
COMPATIBILITY
SEE ALSO

This document was created by man2html, using the manual pages.
Time: 21:32:05 GMT, May 16, 2005



www.fiveanddime.net








Google
Web www.fiveanddime.net