1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Is the primary key column of a table an index in ms sql server?

Question Posted / sanjeev saxena


Is the primary key column of a table an index in ms sql server?..

Answer / Rahul Verma

"Yes, by default when you create a primary key constraint on a table in MS SQL Server, it also creates a unique clustered index on that column."

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How can I know what query is executing by by a particural user? (using sp id or any othe way.)

2 Answers  

Explain triggers in sql?

1 Answers  

Explain try...catch with sql server?

1 Answers  

What are the factors you will check for the performane optimization for a database query?

7 Answers   CarrizalSoft Technologies, DELL, SoftSol,

how can you move the master database

1 Answers   IBM,

What is the difference between mysql and mysqli?

1 Answers   HCL,

What is a select query statement in ms sql server?

1 Answers  

What is subquery explain with example?

1 Answers  

Why use stored procedures in sql server?

1 Answers  

Rate yourself in .NET and SQL ?

1 Answers   Cognizant, HCL, SunGard,

hi ..i am working as a sql dba.....now i want to learn more about t-sql..... is it possible to learn online.... plz refer any site ..thankq

0 Answers   IBM,

What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,

For more SQL Server Interview Questions Click Here
Categories