whenever you create index without specifying the type, its non-clustered.

Which index created when Create Index on table(col), Why

Question Posted / sanjay

Answer Posted / sanjay

whenever you create index without specifying the type, its
non-clustered.

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to turn off warning messages during php execution?

1047

What are views used for?

1017

What is the use of floor function in sql server?

1084

What are the advantages of the mirroring?

1094

How to specify the collation for a character data type in ms sql server?

1031

Why should one not prefix user stored procedures with ‘sp_’?

1048

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

981

What is the difference between a primary key and a unique key? Are they the same?

1077

How to change a login name in ms sql server?

1090

Explain different forms of normalization?

951

Can you use order by when defining a view?

979

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

169

What is 4nf in normalization form?

1029

Does server sql treat char as a variable-length or fixed-length column?

1044

Why are views required in the sql server or in any other database?

965