Required Keyword & Column Identifier | CREATE TABLE (Queue Table Form) | Vantage - 17.10 - QUEUE Keyword - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

Each queue table you define must stipulate the keyword QUEUE as 1 of the CREATE TABLE options following the table name; otherwise, the table you define does not have the properties associated with queue tables and you cannot use consume mode when you select from it (see Teradata Vantage™ - SQL Data Manipulation Language, B035-1146).