Query to list all tables in Oracle NoSQL

136 Views Asked by At

I need to list down all user or system tables available in Oracle NoSQL Database. Please help with query.

Thanks.

1

There are 1 best solutions below

1
Shailendra Mishra On

Which language API are you using. If it is Python the answer is as follows: Let's assume that you have the handle, then the following function will do the job:

def listTables(handle):
    try:
        print('Listing tables')
        ltr = ListTablesRequest()
        lrResult = handle.list_tables(ltr)
        print('Existing tables: ' + str(lrResult))
    except Exception as ex:
        print(ex)
        traceback.print_exc()
    finally:
        print("end table listing")