sp_catalogs (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

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

Requires SELECT permission on the schema.

Examples

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';  

See Also

sp_addlinkedserver (Transact-SQL)
sp_columns_ex (Transact-SQL)
sp_column_privileges (Transact-SQL)
sp_foreignkeys (Transact-SQL)
sp_indexes (Transact-SQL)
sp_linkedservers (Transact-SQL)
sp_primarykeys (Transact-SQL)
sp_tables_ex (Transact-SQL)
sp_table_privileges (Transact-SQL)
System Stored Procedures (Transact-SQL)