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'