Skip to Content
avatar image
Former Member

How to retrieve only the tables present in schema

Hi team,

How do i retrieve the tables present in particular schema.In the other databases like sql/ oracle we have information_schemas where as in sap hana we are using select * from objects which retrieves even the system tables which we dont require.So is there any way to access only the tables present in schema with out passing the schema name in the query.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers