Spanner allows creating tables without explicit primary keys
datagcpengineergcp-spanner
feature
Google Cloud Spanner now supports creating tables without requiring an explicit primary key definition. This feature leverages a hidden `rowid` column as the default primary key, simplifying table creation for certain use cases. This change affects developers and architects working with Spanner who want more flexibility in table schema design.
Features (1) ›
- Spanner
Spanner supports creating tables without defining primary keys. When you create a table without a primary key, Spanner creates a hidden rowid column that serves as the primary key. For more information, see Create a table without defining a primary key .
Read the original announcement →
https://docs.cloud.google.com/release-notes#July_28_2026
Related releases
- Google Cloud Spanner Removes Cumulative DML Transaction Limits Google Cloud Blog ·
- Google Finance Engineering Automates Spanner Dual-Write Migrations Google Cloud Blog ·
- Spanner Adds PostgreSQL-Dialect ILIKE and NOT ILIKE Operators Google Cloud release notes ·
- Google Data Cloud Rolls Out AI-Powered Integrations, Streaming Enhancements, and New Lakehouse Capabilities Google Cloud Blog ·
- Spanner Adds TABLESAMPLE Operator for PostgreSQL-dialect Databases Google Cloud release notes ·
- Cloud Spanner Now Supports Secondary Indexes Based on Scalar Expressions Google Cloud release notes ·