What are primary keys and foreign keys?

Answer Posted / jai prakash chauhan

Primary keys are by default clustered index.

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to define and use table alias names in ms sql server?

571


Can we call future method from trigger?

520


Explain stored procedure?

611


What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

696


What is indexing in sql server with example?

527






What is implicit cursors?

562


What is your recommendation for a query running very slow? : sql server database administration

597


What are the basic functions for master, msdb, model, tempdb databases?

596


What is a trigger in sql server?

545


How to get the definition of a user defined function back?

582


What are the dmvs?

577


can a database be shrunk with users active? : Sql server administration

576


Does sql server 2000 clustering support load balancing?

578


What are the types of database schema? : sql server analysis services, ssas

610


Difference between DELETE and TRUNCATE?

624