Terminology Differences Between ANSI/ISO SQL and Teradata SQL | Teradata Vantage - Terminology Differences Between ANSI/ISO SQL and Teradata SQL - Advanced SQL Engine - Teradata Database

SQL Fundamentals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
zwv1557098532464.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1141
lifecycle
previous
Product Category
Teradata Vantageâ„¢

The ANSI/ISO SQL standard and Teradata SQL occasionally use different terminology. The following table lists the more important variances.

ANSI/ISO SQL Teradata SQL
Base table Table
In the ANSI/ISO SQL standard, the term table means:
  • A base table
  • A viewed table (view)
  • A derived table
Binding style Not defined, but implicitly includes the following:
  • Interactive SQL
  • Embedded SQL
  • ODBC
  • CLIv2
Authorization ID User ID
Catalog Dictionary
CLI ODBC

ANSI CLI is not exactly equivalent to ODBC, but the ANSI standard is heavily based on the ODBC definition.

Direct SQL Interactive SQL
Domain Not defined
External routine function User-defined function (UDF)
Module Not defined
Persistent stored module Stored procedure
Schema User

Database

SQL database Relational database
Viewed table View
Not defined Explicit transaction

ANSI transactions are always implicit, beginning with an executable SQL statement and ending with either a COMMIT or a ROLLBACK statement.

Not defined CLIv2

Teradata CLIv2 is an implementation-defined binding style.

Not defined Macro

The function of database macros is similar to that of ANSI persistent stored modules without having the loop and branch capabilities stored modules offer.