MySQL Removing Some Foreign keys
I have a table whose primary key is used in several other tables and has several foreign keys to other tables. CREATE TABLE … Read more
foreign-keys
How can I find which tables reference a given table in Oracle SQL Developer?
In Oracle SQL Developer, if I’m viewing the information on a table, I can view the constraints, which let me see the foreign … Read more
ERROR: there is no unique constraint matching given keys for referenced table “bar”
Trying to create this example table structure in Postgres 9.1: CREATE TABLE foo ( name VARCHAR(256) PRIMARY KEY ); CREATE TABLE bar ( … Read more
Foreign key constraints: When to use ON UPDATE and ON DELETE
I’m designing my database schema using MySQL Workbench, which is pretty cool because you can do diagrams and it converts them 😛 Anyways, … Read more
Mysql error 1452 – Cannot add or update a child row: a foreign key constraint fails
I’m having a bit of a strange problem. I’m trying to add a foreign key to one table that references another, but it … Read more
Migration: Cannot add foreign key constraint
I’m trying to create foreign keys in Laravel however when I migrate my table using artisan i am thrown the following error: [Illuminate\Database\QueryException] … Read more
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
Why does add a foreign key to the tblDomare table result in this error? The ALTER TABLE statement conflicted with the FOREIGN KEY … Read more
Show constraints on tables command
I have tables that I’ve tried setting PK FK relationships on but I want to verify this. How can I show the PK/FK … Read more
What’s wrong with foreign keys?
I remember hearing Joel Spolsky mention in podcast 014 that he’d barely ever used a foreign key (if I remember correctly). However, to … Read more
INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
I am getting the following error. Could you please help me? Msg 547, Level 16, State 0, Line 1 The INSERT statement conflicted … Read more