Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

sp_catalogs (Transact-SQL)

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

Topic link icon Transact-SQL Syntax Conventions

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



nvarchar( 128)

Name of the catalog


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 Note

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

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

Community Additions

© 2015 Microsoft