Help Center> GaussDB> Centralized_3.x> SQL Reference> SQL Syntax> ALTER DATABASE LINK
Updated on 2024-05-08 GMT+08:00
View PDF

ALTER DATABASE LINK

Description

Modifies database link objects. For details about database links, see DATABASE LINK.

Precautions

Currently, only the username and password can be modified for database links.

Syntax

ALTER [ PUBLIC ] DATABASE LINK dblink
  { CONNECT TO user IDENTIFIED BY password };

Parameters

  • dblink

    Name of a connection.

  • user

    Username for connecting to a remote database.

  • password

    Password for connecting to a remote database.

  • PUBLIC

    Connection type. If PUBLIC is not specified, the database link is private by default.

Parent topic: SQL Syntax