469,936 Members | 2,328 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,936 developers. It's quick & easy.

Primary key

Prompt me, what for need "primary key" in the database table?
Jul 23 '05 #1
4 1440
Primary key is the other way to create a unique clustered index, just like
unique key is equal to create unique nonclustered index. There is no big
difference between primary/unique key contraint v.s direct create unique
clustered/nonclustered index statement.

--
Gang He
Software Design Engineer
Microsoft SQL Server Storage Engine

This posting is provided "AS IS" with no warranties, and confers no rights.
"Alexandr" <al**@trinity.ntu-kpi.kiev.ua> wrote in message
news:20********************@trinity.ntu-kpi.kiev.ua...
Prompt me, what for need "primary key" in the database table?

Jul 23 '05 #2
If a table does not have a primary key, then BY DEFINITION it is not a
table. You need to read a book on RDBMS foundations and the relational
model. .

Jul 23 '05 #3
>> Prompt me, what for need "primary key" in the database table?

Logical identification of an entity.

A key, by definition, is an attribute or set of attributes which can
uniquely identify an entity in the conceptual model. In the logical
representation, a column or set of columns which can uniquely identify a row
in a table is termed as a key. In practice, an entity may have many such
candidates for key ( hence called candidate key ), however for practical
purposes one out of those candidate keys has to be considered primal ( hence
called primary key ). The considerations should include Familiarity (
meaningful & familiar to the user ), Stability ( should not be altered
frequently ), Simplicity ( so that relational expressions can be effective )
and Irreducibility ( or Minimality which loosely suggests no subset of the
key should uniquely identify a row in the table )

--
Anith
Jul 23 '05 #4
Keys are objects in rows, not tables; each row requires one PK.

It is the unique identifier, without which a row cannot be positively
identified.

It allows a row to be connected ('related') to other rows, when the other
row has a field with the same data type and the same value. From there, you
can build relational database systems.
"Alexandr" <al**@trinity.ntu-kpi.kiev.ua> wrote in message
news:20********************@trinity.ntu-kpi.kiev.ua...
Prompt me, what for need "primary key" in the database table?

Jul 23 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by John Simmons | last post: by
9 posts views Thread by 101 | last post: by
4 posts views Thread by Peter | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.