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

Does the order of columns in update statements matter?

672

What happens if strings are casted into wrong code pages in ms sql server?

825

Equi join and non equi join is possible with sql server?

668

What is the use of group by clause?

711

What are the aggregate and scalar functions?

712

explain what is raid and what are different types of raid configurations? : Sql server database administration

732

What is user-defined inline table-valued function?

701

is it important for a database administrator to understand the operating system and file access? : Sql server administration

779

Explain about SQL server 2005?

751

Explain boyce and codd normal form(bcnf)?

701

What is default constraint in ms sql server?

713

List out some of the requirements to set up a sql server failover cluster?

754

can you instantiate a com object by using t-sql? : Sql server database administration

716

How will you hide an attribute? : sql server analysis services, ssas

715

What is simple indexing method?

757