ROA_general_gerneric_Template.png

Check your email or visit Credly to claim and share this badge

View on Credly

Go to My Home

Congratulations

Certificate_icon.png

By completing this SAP Learning Journey, you are now prepared to book your certification exam.

Congratulations!

Mountain_White_background.png

<p>This certification verifies that you possess the required database administration skills in SAP HANA Cloud and SAP HANA for the role of an SAP HANA database administrator. This certification is based on the knowledge gained through the related SAP HANA database administration learning journeys or training courses.</p>

SAP Certified Associate - Database Administrator - SAP HANA

Installing and Administering SAP HANA

Congratulations Modal

Displaying Table Information

<div id="content"><div class="parentsection"><div class="section"><div tabindex="0"><h3>Displaying Table Definition and Content</h3></div><p tabindex="0">The database explorer in SAP HANA cockpit offers options for displaying table definition and content. To display catalog object definitions and change existing catalog objects, you require specific privileges. If these are not granted to you, the error <code><b>Insufficient privilege</b></code> is displayed.</p><div class="kalturaVideoLessonWrapper"><div id="1_ndciljqv" data-testid="video" class="kalturaVideoLessonContainer" aria-label=""></div></div></div></div></div>

Display Table Information

Learn how to open the table definition from the table list in this video. Discover the information displayed in the table definition and gain a better understanding of database operations.<br><br># This description was auto-generated #

Displaying Table Definition and Content

To open the table definition from the table list, right-click the table name, and choose Open from the context menu. The table definition shows the following information. Column name SQL Data Type: The SQL data type the developer would use Column Store Data Type: The data type of the SAP HANA column store Key field: Indicates if the field is a primary key field Not NULL: Indicates if the field can't be NULL Default: Specifies the default value if an INSERT statement does not provide a value for the column Comment: A descriptive comment for the column Note that the table definition is also automatically opened when you choose a table name in the table list. To open the table content from the table list, right-click the table name, and choose Open Data from the context menu. The RAW data tab opens and shows by default the first thousand rows from the table. The Analysis tab provides some monitoring and problem analysis tools that you might need to help you understand what is happening in the database.

Share feedback

Follow guided learning and develop the skills you need at your own pace

Join a moderated learning group to engage with our experts and peers

Find the right learning resources to drive your career as a developer

Sign up to access exclusive student learning journeys

Discover the SAP product knowledge you need to help you progress in your career

Develop your skills

Learn.png

Want to learn more about the value of learning with SAP?

View available SAP Certifications on SAP Learning 

Purchase a subscription and book your exam

Validate your SAP expertise

SAP Certification validates your skills, sets you apart from the crowd, and demonstrates you have the knowledge you need to succeed.

Certify.png

Accelerate your career 

Upskill in key innovation topics through openSAP's free, expert-led online courses, microlearning, and podcasts.

Join SAP Community and connect with a global network of experts and peers to ask and answer questions.

Search for SAP product documentation or browse all SAP Learning Journeys to become competent in the SAP solutions you need.

Log in to SAP Learning Hub and access the entire SAP Learning portfolio, live practice systems, and social learning opportunities.

Find free tutorials, trials, downloads, and technical product information in the SAP Developer Center.

Book live classes (online and in person) and purchase SAP Certification and SAP Learning Hub subscriptions.