- Trending Categories
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
Create table SQL query in SAP HANA
In below SQL query, you can see a create table command in SQL editor to create a new table with name-“Demo_HANA” in schema name AA_HANA11 with column names- ID and NAME and corresponding data types. In the below example, we have defined ID as “Primary Key” which means it is unique and not null.
Create Table Demo_HANA ( ID INTEGER, NAME VARCHAR(10), PRIMARY KEY (ID) );
- Related Articles
- \nLoad and unload a table in SAP HANA using SQL query
- Executing a SQL query in SAP HANA Studio
- Create User SQL in SAP HANA database
- Create View SQL in SAP HANA database
- SQL query to check SAP HANA system version
- SQL statement to create a Restricted user in SAP HANA
- Difference between Open SQL, Native SQL in SAP HANA
- SQL statement to add a table as Virtual table in SAP HANA Smart Data Access
- Sort data in SQL using Dynamic SQL in SAP HANA
- SQL Operation supported in SAP HANA SPS06 SDA
- SQL Operation supported in SAP HANA SPS07 SDA
- Opening SQL editor using SAP HANA Studio
- Changing default schema in SQL console in SAP HANA
- Converting BLOB to Char in SAP HANA using SQL
- Converting BLOB to Char in SAP HANA using SQL

Advertisements