How sp_HelpText work?

Sp helptext provides the information about the code of any SP,Function,view or other objects in database. i.e. definition of that object.

You need to write sp_helptex Object name.

Also you can see the code written behind SP_helptext itself by putting SP_helptext Sp_helptext

Result was interesting. What are your guesses? My team mates and