different fields within tables in schemas

[Former Member]

Hi,

We have different hierarchy for HR and non HR schema. So the same table. For eg : PA0008 in HR schema and non HR schema will have different fields inside it. Is there a way to identify all fields for multiple tables in each schema ?

Now I'm opening table definition of each table and exporting it to excel for checking.

Thanks in advance.

Regards,

Anil

[yeushengteo · Accepted solution]

Hi,

If you have access to the sys table, you can try to retrieve it from the "SYS"."TABLE_COLUMNS"?

E.g:

select * from table_columns

where table_name = 'XXX'

and schema_name = 'YYY'

Regards.

YS

[lbreddemann · Accepted solution]

Hi Yeu

every HANA user has access to the public view TABLE_COLUMNS.

You don't need to put the sys. schema name in front either since there's a public synonym in place for it.

- Lars

[Former Member]

Thanks YS. I got it