Karlee  Will

Karlee Will


Some Useful System Stored Procedures in SQL

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

Some Useful System Stored Procedures in SQL