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

key primary-key hana alter-table
Thorsten Niehues picture Thorsten Niehues · Jun 11, 2015 · Viewed 27.9k times · Source

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

Thorsten Niehues picture Thorsten Niehues · Jun 11, 2015 
ALTER TABLE schema.table ADD PRIMARY KEY (column1,column2)

Related questions

Surrogate vs. natural/business keys

Here we go again, the old argument still arises... Would we better have a business key as a primary key, or would we rather have a surrogate id (i.e. an SQL Server identity) with a unique constraint on the …

Read More
Multi-Column Primary Key in MySQL 5

I'm trying to learn how to use keys and to break the habit of necessarily having SERIAL type IDs for all rows in all my tables. At the same time, I'm also doing many-to-many relationships, and so requiring unique values …

Read More
How do I retroactively add a primary key to my table in rails?

I've created a table without a primary key (:id => false), but now it has come back to bite my ass. My app is already in production and I can't just drop it and recreate another one. Is there a …

Read More