4D v14

ALTER SCHEMA

Home

 
Home
4D v14
4D SQL Reference
SQL Commands
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

 
SEE ALSO 

CREATE SCHEMA

 
ARTICLE USAGE

4D SQL Reference ( 4D v11 SQL Release 4 )
4D SQL Reference ( 4D v14)
4D SQL Reference ( 4D v12.1)
4D SQL Reference ( 4D v13.4)
4D SQL Reference ( 4D v14 R2)
4D SQL Reference ( 4D v14 R3)
4D SQL Reference ( 4D v14 R4)