Informational foreign keys are available in Spanner. Informational foreign keys don't enforce referential integrity and are used to declare the intended logical data model for query optimization
Share
Services
## Feature
Informational foreign keys are available in Spanner. Informational foreign keys don't enforce referential integrity and are used to declare the intended logical data model for query optimization. Enforced foreign keys, which enforce referential integrity, are also available.
Informational foreign keys are supported by GoogleSQL only. Enforced foreign keys are supported by GoogleSQL and PostgreSQL.
For more information, see the following:
* [Types of foreign keys](https://cloud.google.com/spanner/docs/foreign-keys/overview#types-of-foreign-keys)
* [Comparison of foreign key types](https://cloud.google.com/spanner/docs/foreign-keys/overview#comparison-of-foreign-keys-types)
* [Choose which foreign key type to use](https://cloud.google.com/spanner/docs/foreign-keys/overview#choose-foreign-key-type)
* [Use informational foreign keys](https://cloud.google.com/spanner/docs/foreign-keys/overview#use-informational-foreign-keys)
What else is happening at Google Cloud Platform?
App Hub application labels are now attached to your log entries
about 18 hours ago
Services
Share
Google Distributed Cloud (software only) for VMware 1.30.700-gke.56 is now available for download
about 19 hours ago
Services
Share
Anywhere Cache for Cloud Storage is now generally available (GA)
about 20 hours ago
Services
Share