Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Creating a table using SAP HANA Studio UI option
You can also create a table in the HANA database using GUI option in the HANA studio. To create a new table, you need to select Schema right-click → New Table and in the right pane, you can define the table.
In table creation wizard, you need to enter TABLE NAME and Scheme in which you want to create this table and Table Type- Row or Column Store or Table Type.
To add columns to the table, you need to click on “+” sign and a new column is added. You have to define an SQL data type, dimension and Key in the table.
In below Pic, the following details are selected under table creation −
Table Name − DEMO_TABLE
SCHEMA − AA_HANA11
Type − Column Store
Updated on: 22-Jun-2020
304 Views
Advertisements