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