15.00 - Identifying Queue Tables - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Identifying Queue Tables

You can use the DBC.TablesV view to identify and locate queue tables.

The following query reports the names and containing databases for all the queue tables in the Teradata Database.

    SELECT databasename, tablename 
    FROM DBC.tablesV 
    WHERE queueflag = 'y';

See Data Dictionary for more information about the DBC.TablesV view.