Search notes:

SQL Server: sp_helptext

sp_helptext shows the definitions of some objects:

user defined rules
(unencrypted) stored procedures, functions, triggers
computed columns
check constraints
views
system stored procedures

Display the code of sp_helptext itself:

exec sp_helptext 'sp_helptext'

See also

Of course, sp_helptext also shows the definition of itself: sp_helptext 'sp_helptext'

Showing object definitions