United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2005

Product Documentation

SQL Server 2005 Documentation

SQL Server 2005 Books Online

SQL Server Language 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

This topic has not yet been rated - Rate this topic

Catalog Stored Procedures (Transact-SQL)

SQL Server 2005

SQL Server 2005 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)

Help and Information

Getting SQL Server 2005 Assistance

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.