sql - Is it possible to look up a table-valued function's return columns in SAP HANA's dictionary views? -
i've created table-valued function in sap hana:
create function f_tables returns table ( column_value integer ) language sqlscript begin return select 1 column_value sys.dummy; end
now i'd able discover function's table type using dictionary views. can run query here:
select * function_parameters schema_name = '[xxxxxxxxxx]' , function_name = 'f_tables' order function_name, position;
which yield like:
parameter_name table_type_schema table_type_name --------------------------------------------------------------------- _sys_ss2_return_var_ [xxxxxxxxxx] _sys_ss_tbl_[yyyyyyy]_ret
unfortunately, cannot seem able _sys_ss_tbl_[yyyyyyy]_ret
table in sys.tables
(and table_columns
), sys.views
(and view_columns
), sys.data_types
, etc. in order find definitions of individual columns.
note explicitly named table types created using create type ...
appear in sys.tables
...
is there way me formally table-valued function's return columns? i'm not interested in parsing source, obviously.
these kind of tables internal row-store tables, therefore can find _sys_ss_tbl_[yyyyyyy]_ret
table in sys.rs_tables_
. give basic information, including column id (cid
). value important find column information.
for example, if cid 100, can find column information in rs_columns_
table query:
select * sys.rs_columns_ cid = 100
Comments
Post a Comment