Once columns are added, click on Execute. Columns can be added by clicking on + sign, Primary Key can be chosen by clicking on cell under Primary key in front of Column name, Not Null will be active by default. Once you click on New Table → It will open a window to enter the Table name, Choose Schema name from drop down, Define Table type from drop down list: Column Store or Row Store.ĭefine data type as shown below.
Right Click on Table tab under Schema → Select ‘New Table’ option as shown in snapshot given below. Creating Table using GUI OptionĪnother way to create a table in HANA database is by using GUI option in HANA Studio. Open Data Preview/Open Content to see table contents. You can right click on Table name and use Open Data Definition to see data type of the table. Insert statement is used to enter the data in the Table using SQL editor. New Table will be reflected in the list of tables under Schema name. Once statement is successfully executed, right click on Table tab under Schema name in System View and refresh. Successfully executed in 13 ms 761 μs (server processing time: 12 ms 979 μs) − Rows Affected: 0Įxecution statement also tells about the time taken to execute the statement. Statement 'Create column Table Test1 (ID INTEGER,NAME VARCHAR(10), PRIMARY KEY (ID))' Once the statement is executed, we will get a confirmation message as shown in snapshot given below − Once you write Create table SQL query, click on Execute option on top of SQL editor right side. In this SQL statement, we have created a Column table “Test1”, defined data types of table and Primary Key. New table can be created using SQL Create Table statement − Once SQL Editor is opened, Schema name can be confirmed from the name written on the top of SQL Editor. SQL Console can be opened by selecting Schema name, in which, new table has to be created using System View SQL Editor option or by Right click on Schema name as shown below − New tables can be created using the two methods given below − Tables in HANA database can be accessed from HANA Studio in Catalogue tab under Schemas.
0 kommentar(er)
