All Products
Search

This Product

    Hologres:ALTER SCHEMA

    Document Center

    Hologres:ALTER SCHEMA

    Last Updated:Jun 26, 2025

    You can execute the ALTER SCHEMA statement to modify a schema in a database. This topic describes how to use the ALTER SCHEMA statement and the limits on the statement.

    Limits

    You can change only the name of a schema.

    Syntax

    To use the ALTER SCHEMA statement to change the name of a schema, use the following syntax:

    ALTER SCHEMA oldschema RENAME TO newschema;

    Examples

    ALTER SCHEMA my_schema RENAME TO new_schema;
SET search_path TO new_schema; --Go to the renamed schema.