4D v13.4

ALTER SCHEMA

Home

 
4D v13.4
ALTER SCHEMA

ALTER SCHEMA  


 

 

 ALTER SCHEMA sql_name RENAME TO sql_name

The ALTER SCHEMA command can be used to rename the sql_name (first parameter) SQL schema to sql_name (second parameter).

Only the database Designer and Administrator can modify schemas.

Note: You cannot rename the default schema ("DEFAULT_SCHEMA") or the schema containing the system tables ("SYSTEM_SCHEMA") and you cannot use these names in the second sql_name parameter.

Example  

Renaming of the MyFirstSchema schema to MyLastSchema:

ALTER SCHEMA MyFirstSchema RENAME TO MyLastSchema

 
PROPERTIES 

Product: 4D
Theme: SQL Commands

 
INDEX

Alphabetical list of commands

 
SEE ALSO 

CREATE SCHEMA