aws AWS What's New ·

Amazon Aurora DSQL now supports foreign key constraints

dataawsgaengineer
feature

Amazon Aurora DSQL, a serverless and distributed SQL database compatible with PostgreSQL, now supports foreign key constraints. This enhancement allows developers to enforce data integrity rules directly within their database schema, ensuring referential integrity between tables. It prevents writes that would result in invalid references and offers configurable actions like CASCADE or SET NULL for referenced row deletions or updates. The feature is generally available in all AWS Regions where Aurora DSQL operates.

Features (1)
  • Foreign Key Constraints Support in Aurora DSQL

    Aurora DSQL now supports adding foreign key constraints to new and existing tables. This allows applications to define and enforce rules for how tables reference each other, preventing data inconsistencies. Users can choose actions such as NO ACTION, RESTRICT, CASCADE, SET NULL, and SET DEFAULT for handling referenced row deletions or updates.

Read the original announcement →

https://aws.amazon.com/about-aws/whats-new/2026/08/aurora-dsql-foreign-key-constraints/

Related releases