| Author: vipinpaliwal 30 Nov 2007 | Member Level: Gold | Rating:  Points: 2 |
its give erros. because clusterindex also called primary key
|
| Author: Pandian S 30 Nov 2007 | Member Level: Gold | Rating: Points: 2 |
Hi,
YES WE CAN CREATE PRIMARY KEY.
Definition :
---------------
- We can create only one CLUSTERED INDEX in a Table.
- One CLUSTERED INDEX will be created When You create CLUSTERED INDEX On a Table.
- We can create PRIMARY KEY On thet same column.
(BUT THE PRIMARY KEY WILL BE CREATED AS A NON-CLUSTERED)
Regards
|
| Author: Venkatesh Murali 17 Dec 2007 | Member Level: Gold | Rating: Points: 2 |
We can only create PRIMARY KEY On thet same column
|