This is a prerelease version.

DROP MAPPING

The DROP MAPPING statement removes a mapping from the public schema.

Mappings in the partitioned schema cannot be deleted and are not listed in the information_schema tables.

Syntax Summary

This code block is a quick reference with all the parameters that you can use with the DROP MAPPING statement.

For some practical examples, see << examples, Code Examples>>.
DROP MAPPING [IF EXISTS] mapping_name

Parameters

The DROP MAPPING statement accepts the following parameters.

The job_name parameter is required.

Parameter Description Example

IF EXISTS

Fail silently if the mapping does not exist.

mapping_name

The name of the mapping to delete.

Examples

This section lists some example SQL queries that show you how to use the DROP MAPPING statement.

Delete a Mapping

DROP MAPPING IF EXISTS myMap;