Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is a primary key, and how is it different from a unique key?

Answer Posted / nashiinformaticssolutions

• Primary Key:
o Ensures each row in a table is unique.
o Cannot contain NULL values.
o A table can have only one primary key.
• Unique Key:
o Ensures all values in a column are unique.
o Can contain a single NULL value.
o A table can have multiple unique keys.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is trigger a stored procedure?

933


What is procedure and function in sql?

1001


How sql query is executed?

1132


How do you remove duplicates without using distinct in sql?

977


Explain commit, rollback and savepoint.

1002


Can I create table without primary key?

998


What is the use of sqlerrd 3?

944


How can we debug in PL/SQL?

1136


Does inner join remove duplicates?

943


What does t sql mean?

948


how to convert character strings to numeric values? : Sql dba

1106


What is a boolean in sql?

982


How to avoid duplicate records in a query?

1008


explain normalization concept? : Sql dba

1048


Mention what plvcmt and plvrb does in pl/sql?

1143