Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

information_schema in HANA

Hello everybody,

I face this problem:

I need to translate this: the original program gets this info from the information schema from a Postgresql system.

SELECT

  tc.table_name, kcu.column_name

  FROM

  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

Tags:
Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question