LINK TABLE

Core command LINKT

Create a link to a table from a remote database (not available for all databases)

Arguments

connection (mandatory), table name (mandatory)

Examples

LINKT mydb01 CUSTOMERS

Notes

Links a table from another configured connection into the current database: LINK TABLE <connectionId> <tableName>.

Both arguments are mandatory. connectionId must be an existing, reachable connection (checked before linking); tableName is used, unmodified, both as the table being linked in the remote database and as the name it gets in the current database - there is currently no way to link it under a different local name.

Only works when the target connection's configured database type is H2, since it relies on H2's CREATE LINKED TABLE statement (see the H2 documentation for the linked-table grammar). Reports an error if the connection is undefined, unreachable, or not of a supported type. This creates a live link only - it does not copy the remote table's data into the current database.

Last modified in release 5.0.7.