September 2010
Intermediate to advanced
1704 pages
111h 8m
English
Besides using T-SQL commands to create functions, you can also use them to view and modify functions. You can get information by using the provided system procedures and queries against the INFORMATION_SCHEMA.routines view. The following sections describe these methods.
To view the source code for a user-defined function, you can use the sp_helptext procedure:

To display the source code for the functions clearly, configure the SSMS query window to display results as text rather than in the grid by pressing Ctrl+T.
In addition to sp_helptext, you can write queries ...