SYSLIB.SparseTableAMPs is a function that returns the AMPs on which a table, join index, or hash index with a sparse map is defined.
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.
Syntax
[SYSLIB.] SparseTableAMPs ( 'DatabaseNameString', 'ObjectNameString' )
Syntax Elements
- SYSLIB.
- Name of the database where the function is located.
- DatabaseNameString
- The name of the database. The data type is VARCHAR(128).
- ObjectNameString
- The name of a table, join index, or hash index. The data type is VARCHAR(128).