15.00 - Rules and Restrictions for Modifying Queue Tables - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

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

Rules and Restrictions for Modifying Queue Tables

There are a number of restrictions on queue tables, as detailed in the following list.

  • You cannot change a queue table into a non‑queue table.
  • You cannot modify the first column defined for a queue table to be something other than a user‑defined QITS column (see “QITS Column” on page 673).
  • You cannot drop the QITS column from a queue table.
  • You cannot modify the QITS column by adding either of the following attributes.
  • UNIQUE
  • PRIMARY KEY
  • Because of this restriction, you cannot add a simple UPI on the QITS column.

    Similarly, you cannot modify the QITS column to make it a simple UPI.

  • You cannot add either of the following constraints to a queue table definition.
  • FOREIGN KEY … REFERENCES
  • REFERENCES
  • You cannot modify any column of a queue table to have a LOB data type (see SQL Data Types and Literals).
  • You cannot add a permanent journal to the definition for a queue table.
  • You cannot add a reference to queue table columns in a REFERENCES clause for any table.
  • Otherwise, all column‑ and table‑level constraint clauses are valid within queue table definitions with the exception of UNIQUE and PRIMARY KEY constraints not being valid attributes for the QITS column.

  • You cannot modify a queue table definition to have a partitioned primary index.