Browse and Explore Catalog Objects with the Database Objects App

Database Objects is a built-in tool in SAP HANA Cloud Central that enables you to search, view metadata, and generate SQL for catalog objects, right from SAP HANA Cloud Central.

1. To navigate to the Database Objects tool, click on the icon for it on the left-hand side of the instances page.

   

2. Upon opening Database Objects all filters are empty except the Instance Type which pre-selects all types you have existing instances for.

   

   Click the drop down under the Instance filter to select your SAP HANA Database 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 directly 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.

   

Database Objects table features can be leveraged to view table information such as 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. Navigate to settings and enable the functions object type to view functions in the Database Objects app.

   

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 to get SQL that runs the stored procedure.

   

To learn more about exploring database instances in Database Explorer refer to the Browse Schema with the Database Browser in SAP HANA Database Explorer Tutorial

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. Allows for easy access to the object through the Favorites tab.

   

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

   

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

   

4. Navigate to HANA Cloud Central settings to customize preferences for the Database Objects App.

   

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.