Script out a routine (stored procedure) name
Is there a way (at SQL level) to script out the definition of a Cache stored procedure from within SQL?
In SQL Server, I would do...
Select * from INFORMATION_SCHEMA.ROUTINES where ROUTINE_NAME = 'my_sproc_name'
But cant find anyway to do this in cache.
Note, its an old version of Cache, so "INFORMATION_SCHEMA" is not available.
I am trying to see the SQL definition in the sproc from SQL itself.