SelectAllExcludedObjects Stored Procedure | Teradata Vantage - 17.10 - SelectAllExcludedObjects - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Application Programming Reference

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

Displays the list of all user objects whose collections are explicitly excluded from Automated Statistics Management.




Column Description
ObjectType Type or level of exclusion:
  • D (Database)
  • T (Table)
DatabaseName Excluded database or the database containing the excluded table.
TableName Table to be excluded if ObjectType is T. For details, see the ObjectType output parameter.
CreatedTimeStamp Time when the object was excluded.
CreateUser User who imposed the exclusion.

Usage Notes

Returning Result Set

The output of this external stored procedure is in the form of a stored procedure dynamic result. That is, the external stored procedure can return result sets to the client application or to the caller of the external stored procedure (in addition to consuming the result sets itself) upon completion of the external stored procedure.

For more information about stored procedure dynamic result sets, see Teradata Vantageā„¢ - SQL External Routine Programming, B035-1147.

Example: Using SelectAllExcludedObjects

The following example shows how to retrieve a report of all excluded objects defined for the Automated Statistics Management feature.

CALL TDSTATS.SelectAllExcludedObjects;
*** Query completed. 3 rows found. 6 columns returned.
 *** Total elapsed time was 1 second.
ObjectType  DatabaseName  TableName    CreatedTimeStamp    CreateUser
----------  ------------  ---------    ----------------    ----------
    T       PERSONNEL     PROJECT      2010-09-01 23:46:29 DBC
    T       PERSONNEL     DEPARTMENT   2010-09-01 23:48:34 DBC
    T       SALES         SUPPLIER     2010-09-05 21:31:35