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.
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 Form).
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 of the Table operator in Teradata Vantage™ - SQL Data Manipulation Language, B035-1146.