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 drop an existing table?

998

What is the difference between index seek vs. Index scan?

1017

Can I run multiple instances of sql server 2000 at the same time on one computer?

1067

How to create new tables with "create table" statements in ms sql server?

1052

You want to implement the many-to-many relationship while designing tables. How would you do it?

993

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

1034

What are character string data types in ms sql server?

1232

Explain the properties of a relational table?

1013

What is resource db in sql server?

1011

Which command is used for user defined error messages?

1057

How to find Duplicate Records In table?

1008

Explain view in sql server?

1049

Can you use order by when defining a view?

964

What is ssrs?

129

What is index, cluster index and nonclustered index?

985