Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54110 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
What are number line correlation administrators will use while working with a subquery?
List out the difference between union and union all in sql server?
What are the disadvantages of using querystrings to send data from one page to another?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
how would you troubleshoot blocking? : Sql server database administration
How to perform key word search in tables?
When to use null data driven subscription?
Do you know what is fill factor and pad index?
How to create new table with "create table" statements?
What is sql server replication? : sql server replication
What is a with(nolock)?
How do you use a subquery to find records that exist in one table and do not exist in another?
How many types of local tables are there in sql server?
What are examples of triggers?
Do you know what is sql service broker?
