I want to modify Primary key of an existing Table in Spanner from Col1 to combination of Col1 and Col2. Is it possible to do it in Spanner?
This option is not available in Console. Maybe it can be done with a script!
2 Answers
The keys of a table can't change; you can't add a key column to an existing table or remove a key column from an existing table.
Schema and data model | Cloud Spanner Documentation | Google Cloud
GCP Team responded below:
- Only way to do it now is to recreate database using Import/Export functionality
- Feature request is raised on Spanner backlog (no ETA): https://issuetracker.google.com/135719292
Related