Query Statements

Teradata Viewpoint User Guide

brand
Analytical Ecosystem
prodname
Teradata Viewpoint
vrm_release
16.00
category
User Guide
featnum
B035-2206-106K
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.