SQL Server: reveal a function

Self-tutoring about the SQL Server query editor: the tutor mentions a hint.

I defined a function, but then couldn’t find it. I wondered – was it even defined, or had I accidentally deleted it somehow?

The command exec sp_helptext function_name revealed the function definition.

Source:

stackoverflow.com

Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.

Leave a Reply