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
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 ...