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.
| Author |
Topic |
|
veda
Starting Member
5 Posts |
 Posted - 2008-05-14 : 01:57:49
|
I know that primary key is a unique key  .I read somewhere that a table can have both primary key and unique key at a time  .Am I Right? Pl give clarification as asap. Thank Uvedavathi zend |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-14 : 02:04:23
|
| Yup. A table can have a primary key and a unique key. |
 |
|
|
veda
Starting Member
5 Posts |
Posted - 2008-05-14 : 02:23:45
|
| ok!!!!!!!!!!!!!!!!!!!!!!!!Thank Q!!!vedavathi zend |
|
|
|
Sweety
Starting Member
1 Post |
Posted - 2008-05-14 : 13:56:30
|
| The difference between Unique Key and Primary Key is that Primary Key cannot take NULL value, but Unique Key can have a NULL value.-- Sweety. |
|
|
|
veda
Starting Member
5 Posts |
Posted - 2008-05-15 : 01:28:06
|
| Fine..Thank U,Sweety.vedavathi zend |
|
|
|
|
|
|
reg unique key