Primary key : Doen't allow null values Unique key : allow one null va

what is difference between primary key and Unique

Question Posted / hari

Answer Posted / hari

Primary key : Doen't allow null values
Unique key : allow one null value
Primary key create cluster index
Unique Key create non-cluster index

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

your distribution database is full what will u do

2157

Do you know sql server 2008 backup compression?

949

What is the largest component inside a field?

1096

How to execute a sql statement using mssql_query()?

1027

What is difference between joins and subqueries?

1092

What is merge join?

1177

How to select an exiting database using mssql_select_db()?

963

What are trace flags and mention a few common trace flags used with sql server?

1069

You want to implement the many-to-many relationship while designing tables. How would you do it?

977

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1062

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

938

What are the components of sql server service broker?

990

How to create a user to access a database in ms sql server using "create user" statements?

937

How to populate a table in sql server?

940

How to edit table in sql server 2017?

905