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
How you can get a list of all the table constraints in a database? : Sql server administration
How to locate and take substrings with charindex() and substring() functions?
What is difference between join and natural join?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
What is a partitioned view?
What is rank function?
Mention the different authentication modes in sql server.
How to convert character strings into numeric values?
Explain the dbcc pintable command when would you use it?
What are different types of raid configurations? : SQL Server Architecture
How is foreign key related to primary key?
What are the differences between web role and worker role?
Explain multiserver query
What are horizontal and vertical scaling?
How can we improve performance by using SQL Server profiler?
