Skip to Content

How to retrieve only the tables present in schema

May 31, 2017 at 05:30 PM


avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers