Some Useful System Stored Procedures in SQL.
These procedures are built-in procedures and will help to extract the definition and dependencies of the existing user-defined stored procedures.
- sp_help :
- This will display the Stored procedure Name, Schema Name, created date, and Time or if there are any parameters,
- then Parameter Name, Data Type, Length, Precision, Scale, Collation, etc. as result.
- sp_helptext :
- This will display the content of the stored procedure as result.
- sp_depends :
- This will show where the procedure is dependent like name of tables, functions, etc.
#sql #dbms-sql #sql-server