I have a very basic question. I am trying to create a table in HANA DB using HANA Studio SQL script. Now i have a language field in this table to which i need default value to be system logon language if i do not pass the value while updating data.
I know we can use keyword "DEFAULT" to assign a value but cannot find the system variable which can we added there.
CREATE TABLE <table_name> (lang nvarchar(1) DEFAULT <system variable??>);
Please suggest, also as in ABAP we have a structure in data dictionary having list of system fields, similar to that do we have a place in HANA Studio where we can find the list of system variables?
Thanks in advance.