15.00 - Null Statements - Teradata Database

Teradata Database SQL Fundamentals

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

Null Statements

A null statement has no content except for optional pad characters or SQL comments.

Example  

The semicolon in the following request is a null statement.

   /* This example shows a comment followed by 
      a semicolon used as a null statement */
   ;  UPDATE Pay_Test SET ... 

Example  

The first SEMICOLON in the following request is a null statement. The second SEMICOLON is taken as statement separator:

   /*    This example shows a semicolon used as a null 
      statement and as a statement separator */
   ;  UPDATE Payroll_Test SET Name = 'Wedgewood A' 
      WHERE Name = 'Wedgewood A'
   ;   SELECT ...
   -- This example shows the use of an ANSI component
   -- used as a null statement and statement separator ;

Example  

A SEMICOLON that precedes the first (or only) statement of a request is taken as a null statement.

   ;DROP TABLE temp_payroll;