"Yes, by default when you create a primary key constraint on a table i

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

Question Posted / Rahul Verma

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

How to rebuild the master database?

1148

What is self contained sub query?

1130

How to convert numeric expression data types using the cast() function?

1134

Can sql servers link to other servers like oracle?

900

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1015

How can I check that whether automatic statistic update is enabled or not?

1101

Why and when do stored procedure recompile?

1042

What is in place upgrade in sql server?

1113

Explain system functions or built-in functions? What are different types of system functions?

1052

How to connect php with different port numbers?

1159

What is a coalesce function?

1261

What is normalization and what are the advantages of it?

1042

How to provide default values to function parameters?

1235

What kind of problems occurs if we do not implement proper locking strategy?

1479

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1177