sp_catalogs

Transact-SQL Reference

Transact-SQL Reference

sp_catalogs

Returns the list of catalogs in the specified linked server, which is equivalent to databases in Microsoft® SQL Server™.

Syntax

sp_catalogs [ @server_name = ] 'linked_svr'

Arguments

[@server_name =] 'linked_svr'

Is the name of a linked server. linked_svr is sysname, with no default.

Result Sets
Column name Data type Description
catalog_name nvarchar(128) Name of the catalog
Description nvarchar(4000) Description of the catalog
Permissions

Execute permissions default to the public role.

Examples

This 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
EXEC sp_catalogs 'OLE DB ODBC Linked Server #3'

See Also

sp_addlinkedserver

sp_columns_ex

sp_column_privileges

sp_foreignkeys

sp_indexes

sp_linkedservers

sp_primarykeys

sp_tables_ex

sp_table_privileges

System Stored Procedures