can primery key be a non clustered index?

Answer Posted / ivee

yes, it is possible

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to modify an existing user defined function?

772


If no size is defined while creating the database, what size will the database have?

744


How to create a simple stored procedure in ms sql server?

704


Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

705


Describe triggers features and limitations?

679






How to move database physical files in ms sql server?

691


What is subquery explain with example?

796


What is lock escalation? : sql server database administration

804


What are the limitations/drawbacks or ssrs 2008 r2?

105


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

797


What is the return type of executeupdate ()?

692


What are the triggers in sql?

742


what is normalization? Explain different levels of normalization? : Sql server database administration

893


A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

715


What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

746