Catalog stored procedures (Transact-SQL)

Applies to: SQL Server

SQL Server supports the following system stored procedures that implement ODBC data dictionary functions and isolate ODBC applications from changes to underlying system tables.

sp_column_privileges

sp_columns

sp_databases

sp_fkeys

sp_pkeys

sp_server_info

sp_special_columns

sp_sproc_columns

sp_statistics

sp_stored_procedures

sp_table_privileges

sp_tables

Stored procedures for certain platforms only as specified, including Azure Synapse Analytics:

sp_create_openrowset_statistics

sp_drop_openrowset_statistics

Related content

• System stored procedures (Transact-SQL)