16.20 - SHOW MAP - Teradata Database - Teradata Vantage NewSQL Engine

Purpose

Returns the equivalent CREATE MAP statement in SQL or, optionally, XML.

Required Privileges

None.

Syntax

Syntax Element

map_name

Name of an existing contiguous or sparse map to show.

You can show TD_DataDictionaryMap or TD_GlobalMap.

IN XML

Return the MAP object definition in XML format.

Examples

Following is the sample output for a contiguous map.

CREATE MAP TD_Map1 
CONTIGUOUS
AMP BETWEEN <AmpNum1> AND <AmpNum20>
;

Here is the sample output for a sparse map.

CREATE MAP SmallTableMap FROM TD_Map1 SPARSE AMPCOUNT = 1; 

Secure Zones and Sparse Maps

For a sparse map, you must be in the same secure zone as the sparse map.

A zone guest can use SHOW MAP for a sparse map in the same secure zone or sparse maps not contained in the secure zone.