Questions in topic: primary-key - SQL Server Q&A from the SQL Server Central community

x

login about faq Site discussion (meta-askssc)

Questions in topic: primary-key

2

votes

2

answers

175

views

WHAT’S THE DIFFERENCE BETWEEN A PRIMARY KEY AND A CLUSTERED INDEX?

Mar 12 at 02:54 PM Suresh.Patibandla 120

primary-key clustered-index

0

votes

2

answers

359

views

creating a primary key on table with data in it

May 23 '12 at 01:36 PM Fatherjack ♦♦ 38.8k

primary-key

1

votes

1

answers

582

views

Identity as Primary Key, UniqueIdentifier as Foreign Key

Feb 25 '12 at 11:46 AM Grant Fritchey ♦♦ 62.1k

identity foreign-key primary-key

1

votes

4

answers

448

views

Why is PK included in 'recommended' composite index

Nov 07 '11 at 11:35 AM meade 11

primary-key

1

votes

2

answers

1.1k

views

Define UNIQUE Constraint on Composite Key

Apr 12 '11 at 11:40 AM Slick84 1.3k

primary-key composite key unique-constraint

2

votes

6

answers

2.6k

views

Why use an int as a lookup table's primary key?

Mar 25 '11 at 04:40 AM Jaco Briers 23

sql-server primary-key lookups

1

votes

1

answers

956

views

PK, FK and Relationships

Dec 27 '10 at 05:42 AM Fatherjack ♦♦ 38.8k

sql-server-2008 indexing foreign-key primary-key

2

votes

4

answers

378

views

Small doubt in Primary Key?

Dec 18 '10 at 01:42 AM Fatherjack ♦♦ 38.8k

primary-key

1

votes

2

answers

525

views

Delete error

Dec 15 '10 at 03:35 AM Fatherjack ♦♦ 38.8k

foreign-key primary-key constraint

4

votes

6

answers

1.3k

views

Distributed Databases and Primary Keys

Oct 20 '10 at 01:02 PM Mark 2.6k

primary-key distributed

1

votes

2

answers

936

views

can a primary Key and foreign key relation be created between 2 different databases

Sep 29 '10 at 12:17 AM Kev Riley ♦♦ 46.1k

foreign-key primary-key cross-database relationships

0

votes

1

answers

982

views

DDL ERROR.. What is the error here.

Sep 23 '10 at 11:31 AM Fatherjack ♦♦ 38.8k

sql-server-2008 ddl foreign-key primary-key constraint

3

votes

3

answers

2.2k

views

Indexing a GUID

Sep 01 '10 at 07:25 AM Fatherjack ♦♦ 38.8k

indexing primary-key unique

0

votes

1

answers

422

views

Primary Keys creating new

Jul 20 '10 at 04:14 PM technette 847

primary-key

1

votes

3

answers

696

views

Tables without unique ids

Jul 15 '10 at 07:47 AM technette 847

primary-key unique

27 questions

74answers

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Tags

sql-server-2008 × 1601
sql-server × 272
indexing × 111
identity × 32
ddl × 28
foreign-key × 27
primary-key × 27
constraint × 18
unique × 15
clustered-index × 11
cross-database × 10
lookups × 9
relationships × 7
distributed × 5
composite × 4
key × 4
unique-constraint × 4

posts per page 15 30 50

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.