2.3.42 DROP DATABASE LINK

Other Resources

Download Postgres
Free Postgres Training
Webinar: Exploring 10 Postgres Tips and Tricks

Postgres as a Service

Deploy a Managed Postgres Cluster in Minutes! Enterprise-ready and Oracle compatible.

Try it Now Free

2 The SQL Language : 2.3 SQL Commands : 2.3.42 DROP DATABASE LINK

2.3.42 DROP DATABASE LINK

Name

DROP DATABASE LINK -- remove a database link

Synopsis

DROP [ PUBLIC ] DATABASE LINK name

Description

DROP DATABASE LINK drops existing database links. To execute this command you must be a superuser or the owner of the database link.

Parameters

name

The name of a database link to be removed.

PUBLIC

Indicates that name is a public database link.

Examples

Remove the public database link named, oralink:

DROP PUBLIC DATABASE LINK oralink;

Remove the private database link named, edblink:

DROP DATABASE LINK edblink;

See Also

CREATE DATABASE LINK

2 The SQL Language : 2.3 SQL Commands : 2.3.42 DROP DATABASE LINK