Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54316 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / selvaraj.v
No, Because Constraints must have integrity. These are,
Clustered and Non-Clustered. So, to use Primary key with
any one Clustered or Non-Clustered index.
Example in SQL Server 2000:
Query :
-------
create table BookDetails
(
Book_ID int identity(1,1) not null clustered,
Book_Title varchar(20),
Book_Type varchar(15),
Book_Author varchar(25),
Book_Edition float,
Book_Publisher varchar(20),
Book_Pub_Year datetime,
Book_Price int
)
Answer:
-------
Server: Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'clustered'.
Prevent this Error To use Clustered Primary Key:
------------------------------------------------
Query In SQL Server 2000:
-------------------------
create table BookDetails
(
Book_ID int identity(1,1) not null primary key clustered,
Book_Title varchar(20),
Book_Type varchar(15),
Book_Author varchar(25),
Book_Edition float,
Book_Publisher varchar(20),
Book_Pub_Year datetime,
Book_Price int
)
Answer:
-------
The command(s) completed successfully.
| Is This Answer Correct ? | 4 Yes | 21 No |
Post New Answer View All Answers
Explain what is the use of custom fields in report?
Is mysql the same as sql server?
How to use "begin ... End" statement structures in ms sql server?
Why should we go for stored procedures? Why not direct queries?
How would you go about developing a ssrs report?
What are the differences between char and varchar in ms sql server?
What is table join?
What is merge?
When would you use sql joins?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
How to transfer an existing table from one schema to another schema in ms sql server?
How do I get to sql server configuration manager?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
How to recreate an existing index in ms sql server?
Explain the xml support sql server extends?
