Skip to Content

get_object_definition - documentation and value extraction

Jul 19, 2017 at 12:18 PM


avatar image
Former Member


SAP HANA Platform version

While searching for Oracle equivalent of DBMS_METADATA.GET_DDL, get_object_definition procedure was suggested on forums.

I could not find a proper documentation about how the procedure works and how one can control the inclusion/exclusion of object constraints, triggers etc. in the output.

Is there such a documentation available?

Also, how can I read the content of OBJECT_CREATION_STATEMENT into a variable, for further processing?

Thanks & Regards,


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Lars Breddemann
Jul 19, 2017 at 11:28 PM

GET_OBJECT_DEFINITION is an internal HANA package. It's not supported externally nor is it documented.

There is no official equivalent for DBMS_METADATA in HANA.

10 |10000 characters needed characters left characters exceeded