16.20 - 16.50 - Query Statements - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
16.20
16.50
Release Date
July 2021
Content Type
User Guide
Publication ID
B035-2206-071K
Language
English (United States)
You can enter single- or multi-statement SQL queries using Data Definition Language (DDL), Data Control Language (DCL), or Data Manipulation Language (DML) statements in the query box.
DDL statements
Begin with SQL keywords, such as CREATE, ALTER, DROP, DELETE, MODIFY, HELP, SHOW, SET, REPLACE.
DCL statements
Begin with SQL keywords GRANT, REVOKE, GIVE.
DML statements
Begin with SQL keywords, such as SELECT, INSERT, UPDATE.

For single-statement queries, enter the query, optionally followed by a semicolon. For multi-statement queries, each statement must end with a semicolon.