ALTER SCHEMA

Applies to: ❌ Data 360 SQL ✅ Tableau Hyper API

Change properties of a schema.

Syntax 

 
1ALTER SCHEMA <name> RENAME TO <new_name>

Description 

ALTER SCHEMA changes the definition of a schema. Currently, Hyper only supports renaming a schema.

Parameters 
<name>

The name of an existing schema

<new_name>

The new name of the schema. The new name cannot begin with pg_, as such names are reserved for system schemas.

Data 360 REST API Reference
Data 360 SQL Reference
Data 360 SQL and Tableau Hyper API
Data 360 SQL Syntax
Data Types
Scalar Functions
Aggregate Functions
Window Functions
Set Returning Functions
SQL Commands for Tableau Hyper API
External File Support
INSERT
UPDATE
DELETE
TRUNCATE
COPY FROM
COPY TO
CREATE DATABASE
CREATE SCHEMA
CREATE TABLE
CREATE TABLE AS
CREATE EXTERNAL TABLE
ALTER SCHEMA
ALTER TABLE
DROP TABLE
DROP SCHEMA
DROP DATABASE
EXPLAIN
PREPARE
EXECUTE
DEALLOCATE

DID THIS ARTICLE SOLVE YOUR ISSUE?
Let us know so we can improve!