Alex Rivera | Logout

Questions tagged foreign-keys

95 questions · page 2 of 2

Sort by: Newest Votes Active
12
votes
4
answers

Check if a row could be deleted in MySQL

mysql foreign-keys delete-row
asked 2010-09-14T18:37:37.007
79
votes
9
answers

Meaning of "n:m" and "1:n" in database design

mysql database foreign-keys relationship
asked 2010-08-03T14:14:21.260
9
votes
4
answers

Getting Hibernate to generate indexes on foreign keys

hibernate postgresql indexing foreign-keys
asked 2010-06-03T22:17:47.650
315
votes
13
answers

INSERT statement conflicted with the FOREIGN KEY constraint - SQL Server

sql sql-server sql-server-2005 foreign-keys
asked 2010-06-03T12:24:54.647
25
votes
2
answers

T-SQL foreign key check constraint

t-sql foreign-keys constraints
asked 2010-05-28T08:01:14.910
122
votes
3
answers

Django: Set foreign key using integer?

django optimization django-models foreign-keys
asked 2010-05-17T00:09:29.607
23
votes
5
answers

Foreign keys and NULL in mySQL

mysql sql database-design foreign-keys database-relations
asked 2010-05-10T12:26:25.000
12
votes
5
answers

TDD with HSQLDB -- removing foreign keys

hibernate spring tdd foreign-keys hsqldb
asked 2010-04-21T17:47:27.180
65
votes
7
answers

View all foreign key constraints for entire MySQL database

mysql foreign-keys database
asked 2010-04-21T15:53:09.627
698
votes
6
answers

What is related_name used for?

python django foreign-keys many-to-many
asked 2010-04-15T03:51:43.117
52
votes
9
answers

Sqlite / SQLAlchemy: how to enforce Foreign Keys?

python sqlite foreign-keys sqlalchemy
asked 2010-04-10T21:07:15.977
14
votes
4
answers

Foreign keys with Rails' ActiveRecord::Migration?

ruby-on-rails postgresql foreign-keys migration
asked 2010-04-03T22:54:46.680
14
votes
6
answers

Should foreign keys become table primary key?

database primary-key foreign-keys
asked 2010-03-30T14:20:19.340
92
votes
10
answers

Foreign key constraints in Android using SQLite? on Delete cascade

java android sqlite foreign-keys
asked 2010-03-30T13:32:12.710
17
votes
3
answers

Why is django admin not accepting Nullable foreign keys?

django-admin foreign-keys nullable
asked 2010-03-22T15:14:20.890
14
votes
2
answers

How do you add a NOT NULL FOREIGN KEY column to an existing (populated) table in MS SQL?

sql-server sql-server-2005 foreign-keys constraints nullable
asked 2010-03-11T06:51:58.060
11
votes
2
answers

How do I make Django-Piston to include related child objects in the serialized output?

django foreign-keys django-piston
asked 2010-02-21T12:43:11.873
9
votes
1
answers

Entity Framework - How do I join tables on non-primary key columns in secondary tables?

c# entity-framework join mapping foreign-keys
asked 2010-02-17T20:34:17.837
77
votes
2
answers

MySQL - Conditional Foreign Key Constraints

mysql sql database-design foreign-keys polymorphic-associations
asked 2010-01-04T23:12:56.487
43
votes
10
answers

Why do I need to use foreign key if I can use WHERE?

mysql foreign-keys
asked 2009-12-15T13:07:16.317
60
votes
17
answers

Why are foreign keys more used in theory than in practice?

sql database foreign-keys
asked 2009-12-09T18:50:50.407
18
votes
6
answers

What is the problem with foreign key cascade multiple paths and cycles?

sql foreign-keys cascade rdbms-agnostic
asked 2009-10-28T14:41:37.427
109
votes
20
answers

MySQL Creating tables with Foreign Keys giving errno: 150

mysql foreign-keys mysql-error-150
asked 2009-09-21T22:55:47.390
17
votes
6
answers

How can I find unindexed foreign keys in SQL Server

sql sql-server sql-server-2000 foreign-keys
asked 2009-09-10T15:51:32.977
9
votes
2
answers

Is it possible to set a unique constraint as a foreign key in another table?

oracle-database foreign-keys constraints unique
asked 2009-08-24T01:26:32.640
33
votes
2
answers

Hibernate unidirectional one to many association - why is a join table better?

hibernate one-to-many foreign-keys associations
asked 2009-08-20T16:03:32.657
30
votes
2
answers

Insufficient privileges when adding FK constraint (Oracle)

oracle-database foreign-keys
asked 2009-08-11T20:44:08.080
254
votes
21
answers

Mysql error 1452 - Cannot add or update a child row: a foreign key constraint fails

mysql foreign-keys mysql-error-1452
asked 2009-08-10T06:54:18.740
39
votes
4
answers

MySQL errorno 121

mysql foreign-keys mysql-error-1005
asked 2009-07-24T23:30:52.913
10
votes
2
answers

Django: How to follow ForeignKey('self') backwards

django django-models foreign-keys
asked 2009-07-12T00:00:06.723
62
votes
1
answers

Defining foreign key relationships for Rails' models

ruby-on-rails foreign-keys
asked 2009-05-24T18:50:45.053
49
votes
2
answers

A way to check if foreign key exists in SQL 2005

sql sql-server-2005 foreign-keys
asked 2009-05-15T14:35:57.117
18
votes
8
answers

MySQL change type of foreign key

sql mysql foreign-keys
asked 2009-05-06T14:37:31.177
303
votes
9
answers

How to find all tables that have foreign keys that reference particular table.column and have values for those foreign keys?

mysql foreign-keys
asked 2009-04-30T13:45:47.953
11
votes
2
answers

Composite foreign key columns in GORM

grails mapping foreign-keys grails-orm composite
asked 2009-04-28T16:14:08.580
10
votes
3
answers

How to get all tables that have FKs to another table?

oracle-database foreign-keys
asked 2009-04-08T19:10:15.307
15
votes
8
answers

What is a simple example to explain what a foreign key is?

database foreign-keys
asked 2009-03-17T18:12:26.960
68
votes
5
answers

Django model with 2 foreign keys from the same table

django foreign-keys ambiguity
asked 2009-02-24T20:00:11.560
185
votes
10
answers

Does Foreign Key improve query performance?

sql sql-server performance indexing foreign-keys
asked 2009-02-03T14:03:27.570
25
votes
6
answers

Generate Delete Statement From Foreign Key Relationships in SQL 2008?

sql code-generation foreign-keys dynamic-sql
asked 2009-01-27T22:20:41.660
10
votes
1
answers

Django form - in-place edit of data from reverse foreign key join

django forms foreign-keys reverse
asked 2009-01-08T03:54:09.717
9
votes
4
answers

Support for foreign key constraint in Rails

mysql ruby-on-rails foreign-keys
asked 2008-11-26T10:00:48.920
52
votes
5
answers

How to persist an enum using NHibernate

nhibernate enums persistence foreign-keys
asked 2008-11-02T15:30:50.970
27
votes
5
answers

Foreign keys in MySQL?

sql mysql foreign-keys
asked 2008-10-25T16:43:19.380
9
votes
7
answers

Moving from ints to GUIDs as primary keys

sql sql-server foreign-keys primary-key guid
asked 2008-09-26T07:40:27.043
← Prev page 2 of 2