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?
Read update
Services
Share
Announced billing changes for accessing Cloud Storage through BigQuery take effect Feb 21, 2025
February 5th, 2025
Services
Share
Read update
Services
Share
Google SecOps has updated the list of supported default parsers
February 5th, 2025
Services
Share