Yes, we can. for example we can use unique constraint without any cluste

Can we create nonclustered index in a table without
creating a clustered index

Question Posted / neelesh kumar

Answer Posted / neelesh kumar

Yes, we can. for example we can use unique constraint
without any clustered index.

Is This Answer Correct ?

16 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is sharding?

116

What are the purpose of Normalisation?

1093

What does REVERT do in SQL Server 2005?

1009

Explain unique key in sql server?

1049

Where views are stored in sql server?

1026

What is 4nf in normalization form?

1060

What is store procedure?

1111

Explain the stored procedure?

1094

What does normalization do to data?

1137

what are constraints? Explain different types of constraints? : Sql server database administration

1043

Explain filestream storage of sql server 2008?

1072

What encryption security is available in sql azure?

101

what are isolation levels? : Sql server database administration

1058

How fixed length strings are truncated and padded?

1018

How to use go command in "sqlcmd"?

1261