what is difference between primary key and Unique

Answer Posted / naresh

Primary key:it can not be null

Unique:it can have only one null value in a table.

Is This Answer Correct ?    13 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is trigger in salesforce?

672


What is the sql server agent?

776


Explain ms sql server reporting services vs crystal reports?

683


Can we add our custom code in ssis?

717


What is SQL Azure?

100






1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

1724


How do clustered indexes store data?

798


How to loop through result set objects using mssql_fetch_array()?

748


what is bit datatype? : Sql server database administration

651


What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

744


What are the export options of ssrs?

151


Explain transaction server auto commit?

717


How to transfer a table from one schema to another?

741


How will you monitor replication latency in transactional replication? : sql server replication

811


Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

803