DROP storage_format SCHEMA Example | Teradata Database - DROP storage_format SCHEMA Example - Teradata Database

SQL Data Definition Language Syntax and Examples

Deployment: VantageCloud; VantageCore
Edition: VMware; Enterprise; IntelliFlex
Product: Teradata Database
Release Number: 20.00
Publication Date: June 2025
Content Type: SQL Reference
Publication ID: B035-1144-200K
ft:locale: en-US
ft:lastEdition: 2026-09-23
dita:mapPath: mbm1747160743883.ditamap
dita:ditavalPath: jlp1749501702948.ditaval
ft:sourceId: dita
dita:id: mdr1472255012272
lifecycle: latest

This example drops a schema in the Avro storage format of the DATASET type:

DROP Avro SCHEMA chemDatasetSchema;