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:
Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.
Leave a Reply
You must be logged in to post a comment.