Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Can we create clustered index on non primary key column

Answer Posted / laxman2610

Yes, But on that table primary key should be created with
non-clustered index and the columun u want to create a
cluster index is should be unique

Is This Answer Correct ?    7 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you manage sql azure security?

101


Explain mixed authentication mode of sql server?

989


Can two different columns be merged into single column? Show practically?

1013


Why use identity in sql server?

1009


Can sql server 2016 run on windows 7?

861


How can you list all the table constraints in a database?

881


What are the transaction properties?

963


How many types of the database links?

1023


While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

934


What do you understand by physical_only option in dbcc checkdb?

933


What is the difference between indexing and hashing?

1078


Mention the different authentication modes in sql server.

962


How can a user-defined datatype be created?

935


Explain what is the difference between union and union all?

951


whats the maximum size of view state??

2147