Primary Key vs. Unique Index - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Primary Key vs. Unique Index

Author

Topic

jpham
Starting Member

19 Posts

Posted - 2006-07-27 : 12:39:32

Hi All,
What is the major differences between primary key and
unique indexes.
Thanks,
Jodie

nr
SQLTeam MVY

12543 Posts

Posted - 2006-07-27 : 12:41:46

A PK defaults to clustered if there is no clustered index already on the table.
A PK cannot contain nullable columns.
A PK is held as part of the table definition.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.