sp_catalogs (Transact-SQL)

Applies to: SQL Server

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

Syntax

  
sp_catalogs [ @server_name = ] 'linked_svr'

[ @server_name = ] 'linked_svr' Is the name of a linked server. linked_svr is sysname, with no default.

Column name	Data type	Description
Catalog_name	nvarchar(128)	Name of the catalog
Description	nvarchar(4000)	Description of the catalog

Requires SELECT permission on the schema.

The following example returns catalog information for the linked server named OLE DB ODBC Linked Server #3.

Note

For sp_catalogs to provide useful information, the OLE DB ODBC Linked Server #3 must already exist.

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