Chapter 6: Using Stored Procedures

Supported CSPs

The following table shows the supported CSPs and the information that each CSP retrieves.

**Table 6-2: Supported CSPs**
CSP	Information retrieved by the CSP
sp_capabilities	SQL capabilities
sp_column_privileges	Column privilege information for one table
sp_columns	Column descriptions for a table
sp_databases	List of available databases
sp_datatype_info	Datatype descriptions
sp_fkeys	Foreign and primary key relationships
sp_mda	Server metadata
sp_pkeys	Primary key information for a single table
sp_server_info	Server terms, limits, and capabilities
sp_special_columns	Additional column information
sp_sproc_columns	Attributes of procedures input and return parameters
sp_statistics	Statistics and indexes for one table
sp_stored_procedures	List of available procedures
sp_table_privileges	Table privilege information for one table
sp_tables	List of aliases, synonyms, tables, views, and system tables
sp_thread_props	Thread properties

The following sections provide descriptions, syntax, parameters, and usage for the supported CSPs.