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).