4D v16

ALTER SCHEMA

Home

4D SQL Reference
- SQL Commands
- - SQL Commands
  - SELECT
  - INSERT
  - UPDATE
  - DELETE
  - CREATE DATABASE
  - USE DATABASE
  - ALTER DATABASE
  - CREATE TABLE
  - ALTER TABLE
  - DROP TABLE
  - CREATE INDEX
  - DROP INDEX
  - LOCK TABLE
  - UNLOCK TABLE
  - EXECUTE IMMEDIATE
  - CREATE SCHEMA
  - ALTER SCHEMA
  - DROP SCHEMA
  - CREATE VIEW
  - DROP VIEW
  - GRANT
  - REVOKE
  - REPLICATE
  - SYNCHRONIZE

Home

4D v16

4D SQL Reference

SQL Commands

ALTER SCHEMA



	ALTER SCHEMA sql_name RENAME TO sql_name

Description

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