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

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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.