I'm trying to extract Stored procedure DDL by querying system tables.
If I run the following query
select * from dbc.tvm where TableKind = 'P'
both fields RequestText and CreateText contain NULL. Is there any way to query Stored Procedure body apart from using SHOW PROCEDURE?
Thank you.