4D v12.1

ALTER SCHEMA

Home

 
4D v12.1
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.

Example  

Renaming of the MyFirstSchema schema to MyLastSchema:

ALTER SCHEMA MyFirstSchema RENAME TO MyLastSchema

 
PROPERTIES 

Product: 4D
Theme: SQL Commands

 
SEE ALSO 

CREATE SCHEMA