{"id":53164,"date":"2019-04-08T14:42:16","date_gmt":"2019-04-08T09:12:16","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=53164"},"modified":"2021-12-05T21:41:28","modified_gmt":"2021-12-05T16:11:28","slug":"create-tables-in-sap-hana","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/create-tables-in-sap-hana\/","title":{"rendered":"Tables in SAP HANA &#8211; Easy Steps to Create Tables Using SQL Console &amp; Modeler"},"content":{"rendered":"<p>In this tutorial, we will learn how to create tables in SAP HANA within schemas. We will also learn about the types of tables and creating them using SQL Console and\u00a0<strong>SAP HANA Information Modeler<\/strong>. So, let&#8217;s start by discussing the types of tables.<\/p>\n<h3>Types of Tables in SAP HANA<\/h3>\n<p>Tables can be created in SAP HANA to store data from different data sources connected to SAP HANA. Every schema has a table folder under which tables get\u00a0creates. In SAP HANA, there two ways to create a table and there are three types of tables which you can create:<\/p>\n<p>A user can create three types of tables in SAP HANA.<\/p>\n<ul>\n<li><strong>Column Table:<\/strong> The column tables stores data in a columnar (vertical) fashion. The column tables are the most suitable objects and are set as the default table type in SAP HANA. That is all the tables that get replicates,\u00a0save as column tables. Also, column tables are fast in accessing and occupies less storage space as they are highly compressed.<\/li>\n<li><strong>Row Table:<\/strong> The row tables, as opposed to column tables, arranges in a horizontal fashion storing data in rows. We\u00a0mostly use these tables to store metadata, system parameters and system statistics. In some cases, row tables are more efficient than column tables, but from a performance point of view in SAP HANA, column tables are preferred.<\/li>\n<li><strong>Type Table:<\/strong> The type tables are specifically for passing parameters and used when a user creates a calculation view <strong>using SQL statements.<\/strong><\/li>\n<\/ul>\n<h3>Ways of Creating Tables in SAP HANA<\/h3>\n<p>There are two ways of creating tables in SAP HANA. One method is a command line method, where you use the SQL console to write an SQL script and create a table.<\/p>\n<p>The second method is a GUI based method where you use a graphical interface to create a table. Let us learn about the two methods in detail.<\/p>\n<h4>1. Using SQL console<\/h4>\n<p>Firstly, login into the SAP HANA system using the login credentials. We have shown sample usernames for the sake of understanding.<\/p>\n<div id=\"attachment_53173\" style=\"width: 1926px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-System-login-option.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-53173\" class=\"wp-image-53173 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-System-login-option.jpg\" alt=\"Tables - SAP HANA System login option\" width=\"1916\" height=\"970\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-System-login-option.jpg 1916w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-System-login-option-150x76.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-System-login-option-300x152.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-System-login-option-768x389.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-System-login-option-1024x518.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-System-login-option-520x263.jpg 520w\" sizes=\"auto, (max-width: 1916px) 100vw, 1916px\" \/><\/a><p id=\"caption-attachment-53173\" class=\"wp-caption-text\">Login Option in Information Modeler<\/p><\/div>\n<div id=\"attachment_53175\" style=\"width: 1924px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Log-in-details.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-53175\" class=\"wp-image-53175 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Log-in-details.jpg\" alt=\"Tables - Log in details\" width=\"1914\" height=\"929\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Log-in-details.jpg 1914w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Log-in-details-150x73.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Log-in-details-300x146.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Log-in-details-768x373.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Log-in-details-1024x497.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Log-in-details-520x252.jpg 520w\" sizes=\"auto, (max-width: 1914px) 100vw, 1914px\" \/><\/a><p id=\"caption-attachment-53175\" class=\"wp-caption-text\">Entering User Name and Password<\/p><\/div>\n<p><strong>Step 1:<\/strong>\u00a0After logging in to the system, open the SQL Console\/Editor from the icon that the arrow indicates in the image. You can also open the SQL Editor by right-clicking on your system or schema and selecting SQL Editor option.<br \/>\n<a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SQL-editor-option.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53177\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SQL-editor-option.jpg\" alt=\"Tables - SQL editor option\" width=\"1914\" height=\"937\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SQL-editor-option.jpg 1914w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SQL-editor-option-150x73.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SQL-editor-option-300x147.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SQL-editor-option-768x376.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SQL-editor-option-1024x501.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SQL-editor-option-520x255.jpg 520w\" sizes=\"auto, (max-width: 1914px) 100vw, 1914px\" \/><\/a><strong>Step 2:<\/strong> In the SQL console, write the SQL statement for creating a table.<\/p>\n<p>The syntax for creating a table is:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">create &lt;table type&gt; table &lt;table name&gt;(&lt;field name1&gt; &lt;data type&gt;, &lt;field name2&gt; &lt;data type&gt;, \u2026..);<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Column-Type-table.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53178\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Column-Type-table.jpg\" alt=\"Column Type table\" width=\"1169\" height=\"655\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Column-Type-table.jpg 1169w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Column-Type-table-150x84.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Column-Type-table-300x168.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Column-Type-table-768x430.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Column-Type-table-1024x574.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Column-Type-table-520x291.jpg 520w\" sizes=\"auto, (max-width: 1169px) 100vw, 1169px\" \/><\/a><\/p>\n<p>In the image shown above, it is a Column type Table naming customer_3. At the end of this statement, you must also specify the primary key.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Row-type-table.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53179\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Row-type-table.jpg\" alt=\"Row type table\" width=\"1177\" height=\"595\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Row-type-table.jpg 1177w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Row-type-table-150x76.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Row-type-table-300x152.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Row-type-table-768x388.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Row-type-table-1024x518.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Row-type-table-520x263.jpg 520w\" sizes=\"auto, (max-width: 1177px) 100vw, 1177px\" \/><\/a><\/p>\n<p>You can also create a Row Table by mentioning the table type as Row Table in the statement.<\/p>\n<p><strong>Step 3:<\/strong> Execute the newly created table by clicking on the execute button or pressing F8 key.<br \/>\n<a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Execute-Button.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53180\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Execute-Button.jpg\" alt=\"Tables - Execute Button\" width=\"1164\" height=\"589\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Execute-Button.jpg 1164w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Execute-Button-150x76.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Execute-Button-300x152.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Execute-Button-768x389.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Execute-Button-1024x518.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Execute-Button-520x263.jpg 520w\" sizes=\"auto, (max-width: 1164px) 100vw, 1164px\" \/><\/a><strong>Step 4:<\/strong> Once the execution carries out successfully, you can refresh the schema under which the table is made and find the name of the table in the Tables folder.<br \/>\n<a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Name-of-Table-in-Tables-Folder.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53181\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Name-of-Table-in-Tables-Folder.jpg\" alt=\"Name of Table in Tables Folder\" width=\"1513\" height=\"710\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Name-of-Table-in-Tables-Folder.jpg 1513w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Name-of-Table-in-Tables-Folder-150x70.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Name-of-Table-in-Tables-Folder-300x141.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Name-of-Table-in-Tables-Folder-768x360.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Name-of-Table-in-Tables-Folder-1024x481.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Name-of-Table-in-Tables-Folder-520x244.jpg 520w\" sizes=\"auto, (max-width: 1513px) 100vw, 1513px\" \/><\/a><strong>Step 5:<\/strong> You can click on the table name to open the table and look into it.<br \/>\n<a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Table-Display.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53182\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Table-Display.jpg\" alt=\"Table Display\" width=\"1191\" height=\"625\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Table-Display.jpg 1191w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Table-Display-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Table-Display-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Table-Display-768x403.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Table-Display-1024x537.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Table-Display-520x273.jpg 520w\" sizes=\"auto, (max-width: 1191px) 100vw, 1191px\" \/><\/a><em>Note:<\/em> To insert data in the table, write the SQL statement for which the syntax is:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">INSERT INTO &lt;table name&gt; VALUE (\u2018&lt;valueforfield1&gt;\u2019,\u2019&lt;valueforfield2&gt;\u2019\u2026);<\/pre>\n<p>To select a data table:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT*FROM &lt;table name&gt;;<\/pre>\n<h4>2. Using GUI\/Information modeler<\/h4>\n<p>In the GUI based method, you just have to enter some details in an empty tabular structure.<\/p>\n<p><strong>Step 1:<\/strong> Right-click on the Tables folder under the schema you want to create tables in. Click on New Table.<br \/>\n<a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/New-Table-option.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53184\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/New-Table-option.jpg\" alt=\"New Table option\" width=\"477\" height=\"969\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/New-Table-option.jpg 477w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/New-Table-option-74x150.jpg 74w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/New-Table-option-148x300.jpg 148w\" sizes=\"auto, (max-width: 477px) 100vw, 477px\" \/><\/a><strong>Step 2:<\/strong> A table editor will open where you just need to enter relevant details like table name, table type, and schema.<br \/>\n<a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Table-Details-in-table-editor.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53185\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Table-Details-in-table-editor.jpg\" alt=\"Table Details in table editor\" width=\"1915\" height=\"957\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Table-Details-in-table-editor.jpg 1915w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Table-Details-in-table-editor-150x75.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Table-Details-in-table-editor-300x150.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Table-Details-in-table-editor-768x384.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Table-Details-in-table-editor-1024x512.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Table-Details-in-table-editor-520x260.jpg 520w\" sizes=\"auto, (max-width: 1915px) 100vw, 1915px\" \/><\/a><\/p>\n<div id=\"attachment_53186\" style=\"width: 1409px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Main-details-of-table.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-53186\" class=\"wp-image-53186 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Main-details-of-table.jpg\" alt=\"Main details of table\" width=\"1399\" height=\"871\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Main-details-of-table.jpg 1399w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Main-details-of-table-150x93.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Main-details-of-table-300x187.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Main-details-of-table-768x478.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Main-details-of-table-1024x638.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Main-details-of-table-520x324.jpg 520w\" sizes=\"auto, (max-width: 1399px) 100vw, 1399px\" \/><\/a><p id=\"caption-attachment-53186\" class=\"wp-caption-text\">Dimensions of Table<\/p><\/div>\n<p><strong>Step 3:<\/strong> Next is creating the main table where you enter details like column name, SQL data type, dimension, assign a primary key column, select columns as not null, add a default value, comments.<\/p>\n<div id=\"attachment_53187\" style=\"width: 1399px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Main-details-of-table-2.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-53187\" class=\"wp-image-53187 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Main-details-of-table-2.jpg\" alt=\"Main details of table \" width=\"1389\" height=\"865\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Main-details-of-table-2.jpg 1389w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Main-details-of-table-2-150x93.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Main-details-of-table-2-300x187.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Main-details-of-table-2-768x478.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Main-details-of-table-2-1024x638.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Main-details-of-table-2-520x324.jpg 520w\" sizes=\"auto, (max-width: 1389px) 100vw, 1389px\" \/><\/a><p id=\"caption-attachment-53187\" class=\"wp-caption-text\">Default value of Table<\/p><\/div>\n<p><strong>Step 4:<\/strong> The table editor has other tabs as well, such as an Indexed column, Further properties column, Runtime Information column containing different information and details about the table created.<\/p>\n<div id=\"attachment_53194\" style=\"width: 1391px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Indexes-Column-of-Table-Editor.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-53194\" class=\"wp-image-53194 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Indexes-Column-of-Table-Editor.png\" alt=\"Indexes Column of Table Editor\" width=\"1381\" height=\"563\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Indexes-Column-of-Table-Editor.png 1381w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Indexes-Column-of-Table-Editor-150x61.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Indexes-Column-of-Table-Editor-300x122.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Indexes-Column-of-Table-Editor-768x313.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Indexes-Column-of-Table-Editor-1024x417.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Indexes-Column-of-Table-Editor-520x212.png 520w\" sizes=\"auto, (max-width: 1381px) 100vw, 1381px\" \/><\/a><p id=\"caption-attachment-53194\" class=\"wp-caption-text\">Indexes Column of Table Editor<\/p><\/div>\n<div id=\"attachment_53195\" style=\"width: 1385px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Further-properties-column-of-Table-Editor.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-53195\" class=\"wp-image-53195 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Further-properties-column-of-Table-Editor.jpg\" alt=\"Further properties column of Table Editor\" width=\"1375\" height=\"801\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Further-properties-column-of-Table-Editor.jpg 1375w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Further-properties-column-of-Table-Editor-150x87.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Further-properties-column-of-Table-Editor-300x175.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Further-properties-column-of-Table-Editor-768x447.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Further-properties-column-of-Table-Editor-1024x597.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Further-properties-column-of-Table-Editor-520x303.jpg 520w\" sizes=\"auto, (max-width: 1375px) 100vw, 1375px\" \/><\/a><p id=\"caption-attachment-53195\" class=\"wp-caption-text\">Further properties column of Table Editor<\/p><\/div>\n<p><strong>Step 5:<\/strong> Once you enter all the details for the table, execute it by pressing F8 or clicking on the Execute button on the bar.<br \/>\n<a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Execute-Option-in-Table-Editor.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53189\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Execute-Option-in-Table-Editor.jpg\" alt=\"Execute Option in Table Editor\" width=\"1391\" height=\"511\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Execute-Option-in-Table-Editor.jpg 1391w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Execute-Option-in-Table-Editor-150x55.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Execute-Option-in-Table-Editor-300x110.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Execute-Option-in-Table-Editor-768x282.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Execute-Option-in-Table-Editor-1024x376.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Execute-Option-in-Table-Editor-520x191.jpg 520w\" sizes=\"auto, (max-width: 1391px) 100vw, 1391px\" \/><\/a><strong>Step 6:<\/strong> Upon successful execution, you will see a final table.<br \/>\n<a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Final-Table-Display.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53190\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Final-Table-Display.jpg\" alt=\"Final Table Display\" width=\"1389\" height=\"711\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Final-Table-Display.jpg 1389w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Final-Table-Display-150x77.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Final-Table-Display-300x154.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Final-Table-Display-768x393.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Final-Table-Display-1024x524.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Final-Table-Display-520x266.jpg 520w\" sizes=\"auto, (max-width: 1389px) 100vw, 1389px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Step 7:<\/strong> Also, you can find the newly created table in the Tables folder.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/New-table-in-Tables-Folder.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53191\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/New-table-in-Tables-Folder.jpg\" alt=\"New table in Tables Folder\" width=\"310\" height=\"557\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/New-table-in-Tables-Folder.jpg 310w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/New-table-in-Tables-Folder-83x150.jpg 83w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/New-table-in-Tables-Folder-167x300.jpg 167w\" sizes=\"auto, (max-width: 310px) 100vw, 310px\" \/><\/a><\/p>\n<p>You can right-click on the table name to get different options for the table.<br \/>\n<a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Options-by-right-click-on-table-name.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53193\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Options-by-right-click-on-table-name.jpg\" alt=\"Options by right click on table name\" width=\"1851\" height=\"877\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Options-by-right-click-on-table-name.jpg 1851w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Options-by-right-click-on-table-name-150x71.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Options-by-right-click-on-table-name-300x142.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Options-by-right-click-on-table-name-768x364.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Options-by-right-click-on-table-name-1024x485.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Options-by-right-click-on-table-name-520x246.jpg 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Options-by-right-click-on-table-name-720x340.jpg 720w\" sizes=\"auto, (max-width: 1851px) 100vw, 1851px\" \/><\/a><\/p>\n<h3>Summary<\/h3>\n<p>So, this is how we create tables in <strong>SAP HANA<\/strong>. It is a crucial skill to learn because you will get to deal extensively with databases and data tables and require it for creating information models and organizing data.<\/p>\n<p>Do let us know if you have any queries or suggestions in the comment box below.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial, we will learn how to create tables in SAP HANA within schemas. We will also learn about the types of tables and creating them using SQL Console and\u00a0SAP HANA Information Modeler.&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":53198,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18002],"tags":[19381,19379],"class_list":["post-53164","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sap-hana","tag-creating-tables-in-sap-hana","tag-tables-in-sap-hana"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Tables in SAP HANA - Easy Steps to Create Tables Using SQL Console &amp; Modeler - DataFlair<\/title>\n<meta name=\"description\" content=\"Learn to create tables in SAP HANA by using SQL Console and Information Modeler in easy steps and explore the different types of tables.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/create-tables-in-sap-hana\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tables in SAP HANA - Easy Steps to Create Tables Using SQL Console &amp; Modeler - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Learn to create tables in SAP HANA by using SQL Console and Information Modeler in easy steps and explore the different types of tables.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/create-tables-in-sap-hana\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-04-08T09:12:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-05T16:11:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Tables-in-SAP-HANA.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tables in SAP HANA - Easy Steps to Create Tables Using SQL Console &amp; Modeler - DataFlair","description":"Learn to create tables in SAP HANA by using SQL Console and Information Modeler in easy steps and explore the different types of tables.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/create-tables-in-sap-hana\/","og_locale":"en_US","og_type":"article","og_title":"Tables in SAP HANA - Easy Steps to Create Tables Using SQL Console &amp; Modeler - DataFlair","og_description":"Learn to create tables in SAP HANA by using SQL Console and Information Modeler in easy steps and explore the different types of tables.","og_url":"https:\/\/data-flair.training\/blogs\/create-tables-in-sap-hana\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2019-04-08T09:12:16+00:00","article_modified_time":"2021-12-05T16:11:28+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Tables-in-SAP-HANA.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/create-tables-in-sap-hana\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/create-tables-in-sap-hana\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Tables in SAP HANA &#8211; Easy Steps to Create Tables Using SQL Console &amp; Modeler","datePublished":"2019-04-08T09:12:16+00:00","dateModified":"2021-12-05T16:11:28+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/create-tables-in-sap-hana\/"},"wordCount":854,"commentCount":2,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/create-tables-in-sap-hana\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Tables-in-SAP-HANA.jpg","keywords":["Creating Tables in SAP HANA","Tables in SAP HANA"],"articleSection":["SAP HANA Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/create-tables-in-sap-hana\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/create-tables-in-sap-hana\/","url":"https:\/\/data-flair.training\/blogs\/create-tables-in-sap-hana\/","name":"Tables in SAP HANA - Easy Steps to Create Tables Using SQL Console &amp; Modeler - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/create-tables-in-sap-hana\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/create-tables-in-sap-hana\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Tables-in-SAP-HANA.jpg","datePublished":"2019-04-08T09:12:16+00:00","dateModified":"2021-12-05T16:11:28+00:00","description":"Learn to create tables in SAP HANA by using SQL Console and Information Modeler in easy steps and explore the different types of tables.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/create-tables-in-sap-hana\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/create-tables-in-sap-hana\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/create-tables-in-sap-hana\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Tables-in-SAP-HANA.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Tables-in-SAP-HANA.jpg","width":1200,"height":628,"caption":"Tables in SAP HANA"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/create-tables-in-sap-hana\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"SAP HANA Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/sap-hana\/"},{"@type":"ListItem","position":3,"name":"Tables in SAP HANA &#8211; Easy Steps to Create Tables Using SQL Console &amp; Modeler"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/53164","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=53164"}],"version-history":[{"count":16,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/53164\/revisions"}],"predecessor-version":[{"id":105072,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/53164\/revisions\/105072"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/53198"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=53164"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=53164"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=53164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}