Export (0) Print
Expand All

sp_catalogs (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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

Applies to: SQL Server (SQL Server 2008 through current version).

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

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 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';
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft