Top "Foreign-keys" questions

Foreign keys are a data integrity feature of relational (and SQL) databases.

How to add a new column with foreign key constraint in a single statement in oracle

How to add a new column with foreign key constraint in a single statement in oracle?Can any one give …

sql oracle foreign-keys ddl
Hibernate - Foreign keys instead of Entities

Currently, Hibernate allows me to load objects defined by *-to-one relationships directly with entity1.getEntity2() Is it possible to get …

java hibernate mapping foreign-keys
Foreign key not working in MySQL: Why can I INSERT a value that's not in the foreign column?

I've created a table in MySQL: CREATE TABLE actions ( A_id int NOT NULL AUTO_INCREMENT, type ENUM('rate','report',…

mysql foreign-keys innodb mysql-error-1005
Adding constraints in phpMyAdmin

I feel like I'm being stupid, but I can't find anywhere on the phpMyAdmin interface to add constraints to foreign …

mysql foreign-keys phpmyadmin relational-database
Are foreign keys really necessary in a database design?

As far as I know, foreign keys (FK) are used to aid the programmer to manipulate data in the correct …

database oracle foreign-keys
Limit foreign key choices in select in an inline form in admin

The logic is of the model is: A Building has many Rooms A Room may be inside another Room (a …

django foreign-keys inline limit admin
View all foreign key constraints for entire MySQL database

I have a large database with over 150 tables that I've recently been handed. I'm just wondering if there is an …

mysql foreign-keys database
MySQL Foreign Key, Can't create table (errno: 150)

I am trying to build the database and tables for my system. But I found that if I don't add …

mysql foreign-keys mysql-error-1005
How to list out all Foreign Keys with "WITH NOCHECK" in SQL Server

Does anyone know a query for listing out all foreign keys in a database with WITH NOCHECK description applied to …

sql-server sql-server-2005 foreign-keys system
Problems creating a Foreign-Key relationship on Entity Framework

i'm having trouble configuring a foreign key relationship in my Entity Framework fluent Api: Here is the head of the …

c# .net entity-framework ef-code-first foreign-keys