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 to copy the tables, schema and views from one sql server to another?
Explain active/passive and active/active cluster configurations?
What are the requirements for sql server 2016?
Do you know what is user defined datatypes and when you should go for them?
What is data source object?
Why transaction is important?
What is attribute? : sql server analysis services, ssas
What do you think of this implementation? Can this be implemented better?
What is 5nf in normalization form?
Which are the olap features?
What is GUID in sql server?
How do I view views in sql server?
How to choose all records from the table?
How do I make a resultset scrollable?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
