Meaning of Primary Key to Microsoft SQL Server 2008
Posted
by usr
on Stack Overflow
See other posts from Stack Overflow
or by usr
Published on 2010-02-14T22:02:14Z
Indexed on
2010/05/02
12:27 UTC
Read the original article
Hit count: 293
What meaning does the concept of a primary key have to the database engine of SQL Server? I don't mean the clustered/nonclustered index created on the "ID" column, i mean the constraint object "primary key". Does it matter if it exists or not?
Alternatives:
- alter table add primary key clustered
- alter table create clustered index
Does it make a difference?
© Stack Overflow or respective owner