bbCincinnati
Programmer
Hi Folks,
I'm trying to view the definition of a (user defined) function from Query Analyzer. The following statement works well, but the text in the 'definition' column is truncated to maybe 254 characters.
SELECT name, definition
FROM sys.sql_modules AS m
INNER JOIN sys.objects AS o ON m.object_id = o.object_id
WHERE name = 'my_function'
Is there a better way to view the definition of a function from Query Analyzer?
Thank you
I'm trying to view the definition of a (user defined) function from Query Analyzer. The following statement works well, but the text in the 'definition' column is truncated to maybe 254 characters.
SELECT name, definition
FROM sys.sql_modules AS m
INNER JOIN sys.objects AS o ON m.object_id = o.object_id
WHERE name = 'my_function'
Is there a better way to view the definition of a function from Query Analyzer?
Thank you