information_schema in HANA
I face this problem:
I need to translate this: the original program gets this info from the information schema from a Postgresql system.
information_schema.table_constraints AS tc
JOIN information_schema.key_column_usage AS kcu ON tc.constraint_name = kcu.constraint_name
JOIN information_schema.constraint_column_usage AS ccu ON ccu.constraint_name = tc.constraint_name
WHERE constraint_type = 'FOREIGN KEY'
AND ccu.table_name = '_translation'
AND ccu.constraint_schema = 'production'
AND kcu.column_name = 'name'
What this query does is getting all the tables in the system which have a column called "name", and this column is a foreign key to "_translation".
Does anybody know how can I get this system tables information??? Please, I need help!
Thank you very much. Best regards