Maintained with ☕️ by
IcePanel logo

Spanner now lets you use the INTERLEAVE IN clause to colocate child rows with parent rows without enforcing the parent-child relationship

Share

Services

## Feature Spanner now lets you use the [INTERLEAVE IN clause](https://cloud.google.com/spanner/docs/reference/standard-sql/data-definition-language#create%5Ftable) to colocate child rows with parent rows without enforcing the parent-child relationship. When you use INTERLEAVE IN (without the PARENT option), you can insert child rows before inserting the parent row. You can also delete the parent row without affecting the child rows. For more information, see [Create interleaved tables](https://cloud.google.com/spanner/docs/schema-and-data-model#create-interleaved-tables) and [Indexes and interleaving](https://cloud.google.com/spanner/docs/secondary-indexes#indexes%5Fand%5Finterleaving).