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

Popular posts from this blog

java - Plugin org.apache.maven.plugins:maven-install-plugin:2.4 or one of its dependencies could not be resolved -

Round ImageView Android -

How can I utilize Yahoo Weather API in android -