Returns the list of catalogs in the specified linked server. This is equivalent to databases in SQL Server.
Transact-SQL Syntax Conventions
sp_catalogs [ @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
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.
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'
.png)
