Browse and Explore Catalog Objects with the Database Objects App

1. Ensure that your database instance is running before attempting to open the Database Objects app. Once it is started, you can access the app directly by selecting its icon from the left‑hand navigation panel on the Instances page.

   

   You can also open the database objects app through the SQL Console. Make sure you are connected to the correct database, then click the three‑dot menu in the top‑right corner and select Open Database Objects.

   

2. Upon opening database objects, click “Select an Instance” at the top of the page to choose the database you want to work with. You can browse the list or use the search field to quickly find your instance.

   

   

   Once selected, the Schema and Search filter are both available to use. Select the Schema filter and search for the HOTELS schema.

   

   You can also search for the schema or any other objects directly in the Search filter. In this case after searching navigate to the Schemas tab directly to view the metadata for the HOTELS schema. This data includes ownership, privileges and create time.

   

Information for tables includes columns, indexes, properties, runtime information and SQL CREATE Statements.

1. Select the Tables tab to view all associated tables of the HOTELS schema.

   The page now displays all tables in the schema HOTELS and their table type.

   

2. Select the RESERVATION table to explore it further.

   Click the full screen icon on the top right of the screen to maximize the page and view all tabs.

   

   By default you should see the column details for the table.

   

3. Explore the Runtime Information tab, where further information about the table can be found. This information includes the total number of rows, disk size, partitions and memory consumption for the table, as well as individual columns.

   

4. Examine the other tabs, such as CREATE Statements, where SQL code to generate the table can be found.

   

5. Select the Generate SQL Statement dropdown to see the three ways to have SQL generated for the table.

   

1. To display functions in the Database Objects app, click on Select Object Types and turn on the functions object type. The visibility and order of the database objects can be customized by selecting the checkbox and dragging objects by the drag handle icon.

   

2. Open the Functions tab and select AVERAGE_PRICE to examine it further.

   

   Select the Generate SQL Statement dropdown and click SELECT Statement to navigate to the SQL Console.

   

   Input ‘suite’ in the single quotes of the SELECT statement to get the average price for suites.

   

3. Navigate back to the Database Objects app and open the Procedure tab. Select RESERVATION_GENERATOR to examine it further.

   

4. Click Generate SQL and select the CALL statement to get SQL that runs the stored procedure.

   

   The following SQL will be generated:

   SQL Copy

   CALL "HOTELS"."RESERVATION_GENERATOR"(NUMTOGENERATE => /*<INTEGER>*/)

   The parameter NUMTOGENERATE expects an integer value, which specifies how many reservations to generate. Replace /<INTEGER>/ with the desired number of reservations you want the procedure to create.

1. Select the Recent tab to view all the recent objects you opened.

   

2. Navigate to an object and click the star icon on the top right of the screen to favorite it.

   

   Once selected as a favorite, navigate to the Favorites tab to see it.

   

3. Click All/Selected Instance toggle to filter favorites.

   

4. You can also navigate to HANA Cloud Central user settings to customize preferences for the Database Objects App.

   

5. The SAP HANA database explorer extension for Microsoft Visual Studio Code and the SAP Business Application Studio provide a few additional features that developers may find helpful which include the ability to view and download SAP HANA Cloud trace files and the ability to debug SQL Script.

One additional feature that the extension provides is the ability to maintain a list connections to instances. In addition the extension for Visual Studio Code provides an option to maintain these as local connections.

Congratulations! You have now successfully navigated the Database Objects app and learned about the various features and tools available to you right from SAP HANA Cloud Central.