KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Questions tagged
primary-key
60 questions · page 1 of 2
Follow Tag
Sort by:
Newest
Votes
Active
9
votes
3
answers
What happens when auto increment primary key in MySQL comes to maximum
mysql
int
primary-key
auto-increment
asked 2013-07-04T22:12:52.880
8
votes
3
answers
Symfony/Doctrine: DateTime as primary key
datetime
symfony
doctrine
primary-key
asked 2013-06-15T16:50:53.463
11
votes
2
answers
Get all employee who directly or indirectly reports to an employee, with hierarchy level no
sql
sql-server
foreign-keys
iteration
primary-key
asked 2013-04-26T08:56:25.490
41
votes
3
answers
MySQL InnoDB: autoincrement non-primary key
mysql
primary-key
innodb
asked 2012-12-29T22:02:46.277
16
votes
6
answers
Must database primary keys be integers?
mysql
primary-key
asked 2012-12-27T18:52:19.793
10
votes
1
answers
how to tell if column is primary key using mysqli?
php
mysql
mysqli
primary-key
asked 2012-07-11T14:44:59.097
46
votes
1
answers
database: primary key, Clustered or NonClustered
database
sql-server-2008
primary-key
clustered-index
asked 2012-05-22T17:26:16.563
10
votes
2
answers
primary key is always indexed in sql server?
sql-server
indexing
primary-key
clustered-index
non-clustered-index
asked 2012-05-18T19:15:51.520
9
votes
8
answers
How to implement uniqueness where the order of the fields does not matter
sql
sql-server
relational-database
primary-key
foreign-key-relationship
asked 2012-03-14T16:56:58.863
307
votes
15
answers
Difference between primary key and unique key
mysql
sql
database
primary-key
unique-key
asked 2012-03-05T11:39:53.707
210
votes
11
answers
Is there AUTO INCREMENT in SQLite?
sqlite
primary-key
auto-increment
asked 2011-10-26T16:36:20.737
19
votes
8
answers
Efficient method to find collision free random numbers
php
mysql
random
primary-key
asked 2011-07-24T17:45:05.627
9
votes
6
answers
rails3 bigint primary key
ruby-on-rails
ruby-on-rails-3
primary-key
bigint
asked 2011-05-04T07:46:59.457
10
votes
6
answers
Do MySQL tables need an ID?
mysql
primary-key
asked 2011-03-03T22:55:02.590
16
votes
3
answers
UUID versus auto increment number for primary key
primary-key
auto-increment
uuid
asked 2011-03-01T19:36:37.400
12
votes
3
answers
Create join table with no primary key
ruby-on-rails
join
primary-key
has-and-belongs-to-many
asked 2010-10-22T14:38:25.540
126
votes
6
answers
Using a UUID as a primary key in Django models (generic relations impact)
django
django-models
primary-key
content-type
uuid
asked 2010-10-14T18:10:34.780
125
votes
6
answers
Reset PostgreSQL primary key to 1
postgresql
primary-key
reset
asked 2010-09-29T06:36:46.433
35
votes
7
answers
Generating a non-sequential ID/PK for a Django Model
django
url
django-models
primary-key
asked 2010-09-21T09:37:15.647
31
votes
3
answers
What size INT should I use for my autoincrement ids MySQL
mysql
primary-key
auto-increment
asked 2010-08-25T03:52:14.287
13
votes
10
answers
Why do I read so many negative opinions on using composite keys?
sql
ms-access
primary-key
composite-key
composite-primary-key
asked 2010-08-18T13:59:48.267
11
votes
6
answers
Creating django objects with a random primary key
python
django
random
primary-key
asked 2010-07-21T00:17:57.643
58
votes
7
answers
Indexes and multi column primary keys
sql
mysql
primary-key
indexing
asked 2010-06-15T18:55:03.283
15
votes
4
answers
Entity Framework 4: How to find the primary key?
c#
.net
entity-framework
entity-framework-4
primary-key
asked 2010-06-02T15:00:33.690
314
votes
7
answers
How to add an auto-incrementing primary key to an existing table in PostgreSQL?
postgresql
primary-key
auto-increment
asked 2010-05-31T15:31:57.787
41
votes
3
answers
Multi-Column Primary Key in MySQL 5
mysql
key
primary-key
asked 2010-04-15T04:41:51.243
107
votes
5
answers
Why does select SCOPE_IDENTITY() return a decimal instead of an integer?
sql-server
primary-key
scope-identity
asked 2010-04-08T16:20:53.270
14
votes
6
answers
Should foreign keys become table primary key?
database
primary-key
foreign-keys
asked 2010-03-30T14:20:19.340
149
votes
4
answers
Updating MySQL primary key
mysql
primary-key
asked 2010-02-26T12:42:19.063
9
votes
2
answers
SQL Server 2008 Full text search on a table with a composite primary key
sql-server
t-sql
sql-server-2008
full-text-search
primary-key
asked 2010-02-23T01:34:39.127
97
votes
18
answers
Auto Increment after delete in MySQL
sql
mysql
primary-key
auto-increment
asked 2010-02-06T18:21:01.360
25
votes
8
answers
What are the pros and cons of using multi column primary keys?
sql
primary-key
composite-primary-key
asked 2010-02-05T00:58:22.107
16
votes
3
answers
How to alter length of varchar in composite primary key?
sql-server
sql-server-2005
sql-server-2008
primary-key
constraints
asked 2010-01-11T16:48:38.433
17
votes
5
answers
About index and primary key in SQL?
sql
django
primary-key
indexing
asked 2009-12-10T08:53:52.417
39
votes
12
answers
Do link tables need a meaningless primary key field?
sql
database-design
primary-key
asked 2009-12-03T21:57:19.647
32
votes
2
answers
Is it bad to use user name as primary key in database design?
mysql
database-design
primary-key
unique-key
asked 2009-12-01T11:37:08.250
13
votes
6
answers
When not to use surrogate primary keys?
database-design
primary-key
asked 2009-11-11T09:49:36.170
12
votes
4
answers
Is it a good idea to use rowguid as unique key in database design?
sql-server
database-design
primary-key
data-modeling
asked 2009-10-30T18:45:34.067
52
votes
3
answers
Composite Primary Key performance drawback in MySQL
mysql
performance
primary-key
composite-key
asked 2009-09-22T14:34:59.600
20
votes
8
answers
Composite primary key
sql
database
primary-key
composite
asked 2009-09-05T11:09:21.243
21
votes
1
answers
Fluent NHibernate primary key constraint naming conventions
fluent-nhibernate
naming-conventions
primary-key
constraints
asked 2009-08-31T15:35:38.607
15
votes
4
answers
SQL Server Datetime vs Int key performance
sql-server
performance
primary-key
asked 2009-08-31T00:56:39.013
20
votes
5
answers
how to make a composite primary key (java persistence annotation)
java
persistence
annotations
primary-key
many-to-many
asked 2009-07-31T11:36:16.367
174
votes
4
answers
How can I define a composite primary key in SQL?
sql
primary-key
composite-primary-key
asked 2009-07-10T15:44:54.993
18
votes
9
answers
What data type is recommended for ID columns?
language-agnostic
database-design
types
primary-key
database-agnostic
asked 2009-05-31T14:12:50.010
38
votes
9
answers
Hibernate/persistence without @Id
java
hibernate
primary-key
hibernate-annotations
asked 2009-05-29T12:54:06.343
18
votes
11
answers
Should a database table always have primary keys?
database
primary-key
modeling
asked 2009-05-06T21:25:49.340
776
votes
9
answers
SQLite primary key on multiple columns
sqlite
primary-key
ddl
composite-primary-key
asked 2009-04-09T15:17:31.807
9
votes
5
answers
Using both a GUID and an auto-incrementing integer
sql-server
database
indexing
primary-key
guid
asked 2009-04-03T15:28:47.503
24
votes
13
answers
Picking the best primary key + numbering system
database
database-design
primary-key
asked 2009-04-01T22:55:08.063
page 1 of 2
Next →