sp_catalogs (T-SQL)

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'

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

None

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_linkedservers
sp_columns_ex sp_primarykeys
sp_column_privileges sp_tables_ex
sp_foreignkeys sp_table_privileges
sp_indexes System Stored Procedures

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.