sqlmeta.objects.linked_server

Linked Server SQL model class (SQL Server-specific).

Classes

LinkedServer(name[, product, provider, ...])

Represents a linked server (SQL Server-specific).
class sqlmeta.objects.linked_server.LinkedServer(name: str, product: str | None = None, provider: str | None = None, data_source: str | None = None, catalog: str | None = None, username: str | None = None, schema: str | None = None, dialect: str | None = None)[source]

Represents a linked server (SQL Server-specific).

Linked servers allow SQL Server to execute commands against remote databases (SQL Server, Oracle, MySQL, etc.) using distributed queries. Similar to Oracle Database Links.

__init__(name: str, product: str | None = None, provider: str | None = None, data_source: str | None = None, catalog: str | None = None, username: str | None = None, schema: str | None = None, dialect: str | None = None)[source]

Initialize a linked server.

Parameters:

  • name – Linked server name

  • product – Product name (e.g., ‘SQL Server’, ‘Oracle’, ‘MySQL’)

  • provider – OLE DB provider name (e.g., ‘SQLNCLI’, ‘OraOLEDB.Oracle’)

  • data_source – Network name/IP address of remote server

  • catalog – Default database/catalog on remote server

  • username – Login name for remote connection

  • schema – Schema owner (typically dbo)

  • dialect – SQL dialect (typically ‘sqlserver’)

property create_statement: str

Generate CREATE LINKED SERVER statement using sp_addlinkedserver.

Note: For security reasons, passwords are not stored or generated. Login mappings must be configured separately with sp_addlinkedsrvlogin.

Returns:

SQL Server EXEC sp_addlinkedserver statement (without password)

property drop_statement: str

Generate DROP LINKED SERVER statement using sp_dropserver.

Returns:

SQL Server EXEC sp_dropserver statement

__str__() → str[source]

Return string representation of the linked server.

__eq__(other: Any) → bool[source]

Check if two linked servers are equal.

Note: We compare connection parameters but not passwords for security.

__hash__() → int[source]

Return hash of the linked server.