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

Question

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

The ALTER TABLE docu form SAP Library is cryptic to me

Answer 1

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

Answer 2

To add constraints to a column:

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

Answer 3

For creating Primary key on existing table use the following syntax in SQL Console:

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

Here primary_key_alias is the name for the primary key. For more info goto: SAP help