16 lines
549 B
ReStructuredText
16 lines
549 B
ReStructuredText
==============================
|
|
Update a Primary Key
|
|
==============================
|
|
|
|
**Topic: Can you Update a Primary Key in ScyllaDB?**
|
|
|
|
**Audience: ScyllaDB administrators**
|
|
|
|
In ScyllaDB, you cannot update a primary key. It is impossible to do so.
|
|
|
|
However, you can migrate the data from the old table with the old primary key to a new table with a new primary key.
|
|
There are two ways to handle the migration:
|
|
|
|
* Fork-lifting the historical data with the :doc:`Spark Migrator </using-scylla/mig-tool-review/>` tool.
|
|
* Double writing the new data.
|