Skip to Content
0
Nov 24, 2022 at 02:53 PM

In SAP HANA Table Function can we add the data type of a column in return table dynamically

268 Views

Problem Statement:

Hi,

My requirement is if I modify the data type of column in parent table, in Table function also it needs to be updated automatically. Currently depending the data type of parent table we are manually giving the data type(in return table) of a column in table function(i.e nvarchar, nbinary).

Is there any way in table function to pass the data type of a column dynamically based on the parent column datatype.