Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vinoth
Yes,Its Possible.Eg( Select Eid,Did,Ename from Employee)
.Create table with primary key column(Eid).This time
Primary key column ACT As a CLUSTERDE INDEX for Default.
Suppose User directly create Did COLUMN with CLUSTEREDINDEX
at this time Primary key column act as a NONCLUSTEREDINDEX.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the drawbacks of reporting in ssrs?
What types of Joins are possible with Sql Server?
Is BCNF better than 2NF & 3NF? Why?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
What is user-defined function?
how many clustered indexes can be created on a table? : Sql server database administration
What is raid? : SQL Server Architecture
What are the types of processing and explain each? : sql server analysis services, ssas
Do you know what is a trace frag? Where do we use it?
How to change the system date and time from SQL Plus Terminal ?
what is denormalization and when would you go for it? : Sql server database administration
What is pessimistic concurrency?
What is the difference between deallocate cursor and close cursor?
What do you mean by a dependent functionality in a build?
How to delete duplicate rows?
