DROP REMOTE SERVER ​

Drop an existing remote server that is used for replication.

DROP REMOTE SERVER [IF EXISTS] name

If you specify the IF EXISTS option, the system does not return a warning if the remote server does not exist.

You cannot drop a remote server that is referenced by an existing replica (regardless of whether replication is running).

Examples ​

yellowbrick=# drop remote server ybd_repl_svr;
DROP REMOTE SERVER

premdb=# drop remote server if exists ybdrepl3;
DROP REMOTE SERVER

Parent topic:SQL Commands