Stored Procedures–Catalog Stored Procedures

Catalog stored procedures provide a uniform catalog interface for accessing database gateways as well as SQL Server from the same application. These stored procedures are compatible with the catalog interface for the Microsoft Open Database Connectivity (ODBC) API.

These are the SQL Server catalog stored procedures:

sp_column_privileges sp_special_columns
sp_columns sp_sproc_columns
sp_databases sp_statistics
sp_datatype_info sp_stored_procedures
sp_fkeys sp_table_privileges
sp_pkeys sp_tables
sp_server_info

Some of these stored procedures support wildcard pattern matching for some parameters. Wildcard pattern matching allows you to substitute the % and _ characters for one or more characters in the parameter, just as in a LIKE expression in Transact-SQL. For example, to find all tables in the current database starting with the letter s, type:

sp_tables 's%'

For details about catalog stored procedures, see the description of the specific catalog stored procedure in the following sections or see the Microsoft ODBC Programmer's Reference and SDK Guide, available separately.