Syntax
------ 
DROP SERVER [ IF EXISTS ] server_name
 
Description
----------- 
Drops the server definition for the server named
server_name. The
corresponding row within the mysql.servers table will be
deleted. This
statement requires the SUPER privilege. 
 
Dropping a server for a table does not affect any
FederatedX, FEDERATED or Spider tables that used this
connection information when they were created. 
 
IF EXISTS
 
If the IF EXISTS clause is used, MariaDB will not return an
error if the server does not exist. Unlike all other
statements, DROP SERVER IF EXISTS does not issue a note if
the server does not exist. See MDEV-9400.
 
Examples
-------- 
DROP SERVER s;
 
IF EXISTS:
 
DROP SERVER s;
 
ERROR 1477 (HY000): The foreign server name you are trying
to reference 
 does not exist. Data source error: s
 
DROP SERVER IF EXISTS s;
 
Query OK, 0 rows affected (0.00 sec)
 


URL: https://mariadb.com/kb/en/drop-server/