Query Statements

Teradata® Viewpoint User Guide

brand
Analytical Ecosystem
prodname
Teradata Viewpoint
Teradata Workload Management
vrm_release
16.20
category
User Guide
featnum
B035-2206-107K
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.