15.00 - Terminology Differences Between ANSI/ISO SQL and Teradata SQL - Teradata Database

Teradata Database SQL Fundamentals

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1141-015K

Terminology Differences Between ANSI/ISO SQL and Teradata SQL

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 Teradata Database macros is similar to that of ANSI persistent stored modules without having the loop and branch capabilities stored modules offer.