Skip to Content
avatar image
Former Member

Viewing the SQL within the standard HANA procedures

Hi all,

I would like to see the SQL to be executed when I call for the procedure e.g. CHECK_TABLE_CONSISTENCY

Is that possible?

I tried to click on Catalog > SYS > Procedures > Right click on the procedure & "Open Definition"
I can see there's a "create procedure" statement, but do not see the statement that would be executed by this procedure.

Please advise.


Thanks,
Henry

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 03, 2014 at 02:39 PM

    Hi Henry,

    As far as I know, the content of most built-in stored procedures are not visible. When you open the definition, you can just see something like "CREATE PROCEDURE XXX (XXX, XXX, ...) AS BUILT IN".

    Best regards,

    Wenjun

    Add comment
    10|10000 characters needed characters exceeded