AWS Database Blog

Rekha Reddy Anupati

Author: Rekha Reddy Anupati

Working with foreign key constraints in Aurora DSQL

Working with foreign key constraints in Aurora DSQL

Amazon Aurora DSQL supports foreign key constraints, letting you enforce referential integrity directly in the database. This post covers defining foreign keys, immediate versus deferred enforcement, adding constraints to existing tables, and how optimistic concurrency control resolves conflicts in distributed workloads.