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