See Reference Manual: Procedures for details.
sp_column_privileges table_name [, table_owner [, table_qualifier [, column_name]]]
sp_columns table_name [, table_owner ] [, table_qualifier] [, column_name]
sp_databases
sp_datatype_info [data_type]
sp_fkeys pktable_name [, pktable_owner] [, pktable_qualifier] [, fktable_name] [, fktable_owner] [, fktable_qualifier]
sp_pkeys table_name [, table_owner] [, table_qualifier]
sp_server_info [attribute_id]
sp_special_columns table_name [, table_owner] [, table_qualifier] [, col_type]
sp_sproc_columns procedure_name [, procedure_owner] [, procedure_qualifier] [, column_name]
sp_statistics table_name [, table_owner] [, table_qualifier] [, index_name] [, is_unique]
sp_stored_procedures [sp_name [, sp_owner [, sp_qualifier]]]
sp_table_privileges table_name [, table_owner[, table_qualifier]]
sp_tables [table_name] [, table_owner] [, table_qualifier][, table_type]