United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2008

Product Documentation

SQL Server 2008 Books Online

Database Engine

Technical Reference

Transact-SQL Reference

System Stored Procedures (Transact-SQL)

Catalog Stored Procedures (Transact-SQL)

sp_column_privileges (Transact-SQL)

sp_columns (Transact-SQL)

sp_databases (Transact-SQL)

sp_fkeys (Transact-SQL)

sp_pkeys (Transact-SQL)

sp_server_info (Transact-SQL)

sp_special_columns (Transact-SQL)

sp_sproc_columns (Transact-SQL)

sp_statistics (Transact-SQL)

sp_stored_procedures (Transact-SQL)

sp_table_privileges (Transact-SQL)

sp_tables (Transact-SQL)

Minimize

2 out of 2 rated this helpful - Rate this topic

Catalog Stored Procedures (Transact-SQL)

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_special_columns
sp_columns	sp_sproc_columns
sp_databases	sp_statistics
sp_fkeys	sp_stored_procedures
sp_pkeys	sp_table_privileges
sp_server_info	sp_tables

Reference

System Stored Procedures (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.