Events
Sep 15, 6 AM - Sep 17, 3 PM
The best SQL community-led learning event. Sept 2025. Save €200 with code FABLEARN.
Get registeredThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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
Sep 15, 6 AM - Sep 17, 3 PM
The best SQL community-led learning event. Sept 2025. Save €200 with code FABLEARN.
Get registered