sp_helptext « System Functions « SQL Server / T-SQL Tutorial

25.46.1.Displays the contents of a stored procedure, a trigger, or a view.
25.46.2.How to use the sp_HelpText system stored procedure
25.46.3.EXEC sp_helptext on a view
25.46.4.The sp_helptext system stored procedure gives you a source listing of another procedure, if it was not created with the WITH ENCRYPTION option.