ALTER ZONE Examples | Teradata Database - ALTER ZONE Examples - Teradata Database

SQL Data Definition Language Syntax and Examples

Deployment: VantageCloud; VantageCore
Edition: VMware; Enterprise; IntelliFlex
Product: Teradata Database
Release Number: 20.00
Published: June 2025
ft:locale: en-US
ft:lastEdition: 2026-09-23
dita:mapPath: mbm1747160743883.ditamap
dita:ditavalPath: jlp1749501702948.ditaval
dita:id: mdr1472255012272
lifecycle: latest

Example: Add Root

ALTER ZONE zn_01 ADD ROOT zn_rt01;

Example: Drop Root

ALTER ZONE zn_01 DROP ROOT;