DROP SERVER

This MySQL statement can be used with the FEDERATED storage engine to delete a given server that was created with CREATE SERVER.

Syntax

Below is the syntax for this command. Text within square brackets (i.e, [ and ] ) are optional. Choices are separated by bars (i.e, | ). Ellipses preceded by a comma indicates a repeating pattern. Ellipses before or after syntax are used to highlight a relevant except from the larger syntax. Text displayed in italic letters represent text that should be replaced with the specific names related to the database (e.g., column with the name of the column).

DROP SERVER [IF EXISTS] server

Explanation

This MySQL statement can be used with the FEDERATED storage engine to delete a given server that was created with CREATE SERVER. The IF EXISTS flag may be given to prevent an error from being generated if the server does not exist. Any tables created with a CONNECTION to a FEDERATED server will not be dropped or altered as a result of this statement. See the explanation in our MySQL documentation for the CREATE SERVER statement for more information on this topic. This MySQL statement was introduced in version 5.1.15 of MySQL and requires SUPER privileges.

Examples

Below is an example of this MySQL statement:

DROP SERVER server1;