Questions tagged [primary-key]

9

votes

3

answers

What happens when auto increment primary key in MySQL comes to maximum

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

Questions tagged primary-key