“sp_helptext“ – Useful command to view detail TIP #85


It might be already known to you but I thought for sharing because I frequently use this command and it is very useful command.

When someone wants to determine detail of a function or stored procedure he/she can use this useful command.

The syntax is very simple. Just write

sp_helptext Storedprocedure/ functionname

For example If I want to determine detail of a stored procedure “proc_FindStudentUsingCorrect” then I have to write following command

sp_helptext proc_FindStudentUsingCorrect

see below snap for detail



You can now copy the result text and check what exactly written in the stored procedure or function.

I hope you will use it in your day to day practice.



Leave a Reply

Your email address will not be published. Required fields are marked *