SQL Server common system stored procedures Daquan

1. sp_help Report about database objects (all objects listed in Sys.sysobjects compatibility view)

sp_help table name, stored procedure name, etc.

2. sp_helpdb report effective information about the database

sp_helpdb database name

3. sp_helptext Default value, unencrypted Transact-SQL stored procedure. User-defined Transaction-sql function. Trigger. computed columns, check constraints, view live system objects

Sp_helptext stored procedure name, etc.

4 sp_helpindex View information about indexes on a table or view

Sp_helpindex Table Name

5. Sp_refreshview is used to update metadata for a specified view that is not bound to a schema.

Sp_refreshview View Name

6. sp_rename changing the name of a stored procedure

sp_rename old stored procedure name, new stored procedure name

SQL Server common system stored procedures Daquan