15.00 - Identifying 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

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.