Teradata.syn - Teradata SQL Assistant

This file contains an example for each Teradata statement. This information can be viewed in the Favorites window, or within the Query Builder.

The file consists of one definition for each example. Each definition contains two parts and can span multiple lines in the file. The two parts are separated by the string ~|~ and the definition ends with the string |~|.

The first part is the statement keyword itself – possibly followed by text within parenthesis. This extra text is used when multiple examples are defined for a single statement.

The second part is the example itself. This will be displayed, and optionally inserted into a query, exactly as entered in this file.

Example:

CREATE DATABASE~|~CREATE DATABASE finance
   FROM ApplDb
AS
   PERM = 2000000 SKEW = 100
   SPOOL = 5000000
   FALLBACK
   ACCOUNT= 'ACCTG'
   NO AFTER JOURNAL
   DUAL BEFORE JOURNAL
   DEFAULT JOURNAL TABLE = finance.journals;|~|
DROP DATABASE~|~DROP DATABASE MyDb;|~|
SELECT (Aggregate)~|~SELECT COUNT(employee)
  FROM Department
  WHERE DeptNo > 100
  HAVING COUNT(employee) > 10 ;|~|