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.
Returns the list of catalogs in the specified linked server. This is equivalent to databases in SQL Server 2005.
.gif "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
Reference
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)