How to add a (primary) key to an existing table using SAP HANA

Question

What is SQL command to add (primary) key to table in SAP HANA?

+3

Thorsten niehues June 11. 15 at 10:58 am

3 answers

Thorsten niehues · Answer 1 · 2015-06-11T10:58:02+0000

ALTER TABLE schema.table ADD PRIMARY KEY (column1,column2)

Manish gupta · Answer 2 · 2016-04-25T11:59:23+0000

To create a primary key on an existing table, use the following syntax in the SQL console:

alter table "schemaName"."tableName" add constraint primary_key_alias Primary KEY("Column_Name");

Where primary_key_alias is the name of the primary key. For more information: SAP Help

KABIL ARASAN · Answer 3 · 2017-07-31T11:48:01+0000

To add constraints to a column:

alter table "Schema_Name"."Table_Name"  add primary key ("Column_Name");