DROP USER MAPPING
Removes a user mapping for a foreign server.
Synopsis
DROP USER MAPPING [IF EXISTS] { <username> | USER | CURRENT_USER | PUBLIC }
SERVER <servername>Description
DROP USER MAPPING removes an existing user mapping from a foreign server.
To run this command, the current user must be the owner of the server containing the mapping.
Parameters
| Parameter | Description |
|---|---|
IF EXISTS |
Do not throw an error if the user mapping does not exist. Greengage DB issues a notice in this case |
username |
User name of the mapping.
|
servername |
Server name of the user mapping |
Examples
Remove the user mapping for user bob for server foo, if it exists:
DROP USER MAPPING IF EXISTS FOR bob SERVER foo;Compatibility
DROP USER MAPPING conforms to ISO/IEC 9075-9 (SQL/MED).
The IF EXISTS clause is a Greengage DB extension.