sys.sp_catalogs

Description

Returns the list of catalogs in the specified linked server. This is equivalent to databases in SQL ## Syntax

sp_catalogs [ @server_name = ]
N
'server_name'
[ ; ]

Examples

Example 1

CATALOG_NAME

Example 2

DESCRIPTION

Example 3

SELECT

Example 4

sp_catalogs [ @server_name = ]
N
'server_name'
[ ; ]

Example 5

OLE DB ODBC
Linked Server #3

Example 6

sp_catalogs

Example 7

OLE DB ODBC Linked Server #3

Example 8

USE master
;
GO
EXECUTE sp_catalogs
'OLE DB ODBC Linked Server #3'
;

Example 9

@table_schema =
'HumanResources'
,
@table_catalog =
'AdventureWorks2022'
;