Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server
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 = ] N'server_name'
[ ; ]
The name of a linked server. @server_name is sysname, with no default.
Column name | Data type | Description |
---|---|---|
CATALOG_NAME |
nvarchar(128) | Name of the catalog |
DESCRIPTION |
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
.
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';
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register today