Tag: referential-integrity


Found 45 results for 'referential-integrity'.


1) postgresql - What is the correct way to map relationships between structurally similar comments tables and commentable entities?
2) sql-server - Do I need a separate Id column for this "mapping" table?
3) database-design - Are there DBMS that allow a Foreign Key that References a View (and not only base tables)?
4) mysql - How do I prove that the act of removing foreign keys doesn't corrupt existing data?
5) database-design - DB Design. Tracking history without losing referential integrity
6) database-design - Table design when one data is dependant of another and the second one has repeated values
7) sql-server - Referential integrity when two FK columns need to match themselves in the same table?
8) postgresql - two-table-over <+> functional relationship: maintaining referential integrity
9) database-design - How to maintain referential integrity of an object graph when a node is deleted
10) sql-server - Complex Delete Cascade Including Self-Referencing Table
11) postgresql - Make a boolean column unique per group
12) database-design - Help with good RDBMS transactional schema design that mimicks a sports league
13) sql-server - Enforce referential integrity between two groups of data
14) oracle - Oracle parent child move failed
15) sqlite - SQL - Referential integrity
16) mysql - the REFERENCES privilege is only about creating a foreign key constraint? Practical use cases?
17) mysql - Large hexadecimal PRIMARY KEY - how to index substrings of the PK field?
18) database-design - Lookup table for a one-to-many relationship
19) database-design - Enforcing existence of records while avoiding circular references
20) oracle - FK to table with non-unique values via a on commit refreshing materialized view?
21) mysql - In MySQL, can I defer referential integrity checks until commit
22) postgresql - Delete rows while updating references
23) nosql - Inconsistency in Relational Databases
24) mysql - Ensure integrity of other columns from foreign record
25) oracle - Truncate parent table in Oracle when child table is empty
26) sql-server - SQL Server 2008r2 replication from multiple sources
27) sql-server - Finding a good DB design for my project
28) postgresql - Enforcing constraints "two tables away"
29) sql-server - Cascade primary key update to all referencing foreign keys
30) mysql - mysql disable referential integrity
31) postgresql - Better way to ensure referential integrity of one column to a composite primary key?
32) postgresql - Deleting would-be orphans when creating FK in Postgres
33) database-design - How to model a 1..1 Composition Relationship
34) sql - PostgreSQL Error: there is not unique constraint matching given keys for referenced table
35) sql-server - Hierarchical references abstraction with strict model
36) sql-server - Is having relationships between separate databases bad practice?
37) sybase - How do I identify tables that have a foreign key to a specific table in Sybase?
38) sql-server - How can I change Referential Integrity from a Unique Key Constraint to a Primary Key?
39) db2 - set integrity not enforced in DB2
40) mysql - If foreign keys/cascade deletes are bad, why use a database-server with that feature?
41) sql-server - Preferred design to avoid circular/multiple update paths
42) sql-server - Want to Set Relationship Between 3 Tables (1st Child Table column value depends between two another table columns)
43) foreign-key - Does SQL manage foreign key constraints in terms of insertion?
44) sql-server - Referential Integrity - Indirect Foreign Key In "Depth"
45) database-design - Referential Integrity - Re-using table