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: 269

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:

  1. alter table add primary key clustered
  2. alter table create clustered index

Does it make a difference?

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about sql-server-2008