16.20 - DROP 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
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

Purpose

Drop a contiguous or sparse map.

When a map is dropped, the map is revoked from PUBLIC, users, and roles.

Required Privileges

You must have the DROP MAP privilege.

Syntax



Syntax Elements

map_name
Name of the existing contiguous or sparse map to drop.
You cannot drop a contiguous map on which sparse maps are based.
You cannot drop TD_DataDictionaryMap, TD_GlobalMap, or the system-default map.

Example: Dropping a Map

This statement drops the map, SmallTableMap.

DROP MAP SmallTableMap;

Secure Zones and Dropping a Map

Users and users with roles within a secure zone cannot drop a sparse map created in another secure zone, cannot drop a sparse map not specific to a secure zone, and cannot drop a contiguous map.

Only user DBC can drop a sparse map created in another secure zone.

Dropping a Map that Contains Tables

You cannot drop a map that contains tables. You must move the tables to another map before you can drop the map. See ALTER TABLE Map and Colocation.

Dropping a Default Map

You cannot drop the default map for a user, database, or profile. You must set the default map to null or to another map before you can drop the map. See the DEFAULT MAP option for MODIFY USER, the DEFAULT MAP option for MODIFY DATABASE, or the DEFAULT MAP option for MODIFY PROFILE, as appropriate.

Dropping a Map Used by a Table Operator

You cannot drop a map that is being used by a table operator. See the EXECUTE MAP option under "Table Operator" in Teradata Vantage™ SQL Data Manipulation Language , B035-1146 .