Returns the list of catalogs in the specified linked server. This is equivalent to databases in SQL Server.
.gif)
Transact-SQL Syntax Conventions
sp_catalogs [ @server_name = ] 'linked_svr'
- [ @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
|
|
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.
.gif) 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'
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)
Help and Information
Getting SQL Server 2008 Assistance