answersLogoWhite

0

Primary key is a type of unique index with no null constraint on the columns involved. There can only be one Primary key whereas you can create other unique indexes on the table.

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

What is the difference between a Primary Key and a Secondary Key?

A Primary Key is a unique identifier for each record in a database table and is used to enforce entity integrity. A Secondary Key is a non-unique index that is used for querying and organizing data efficiently but does not have the constraint of uniqueness.


Difference between foreign key and composite key?

primary key: primary creates a clustered index on the column and it doesn't allow null values. unique key: unique key creates non clustered index by default.it allows "one null value". foreign key: A foreign key (FK) is a column or combination of columns used to establish and enforce a link between the data in two tables. Fore More information, you can visit this website:http://www.iyogibusiness.com


What is the index error in theodolite?

Half of the difference between the two positions is called the "index error".


Is there any difference between index and indicator?

yes there iis


What are the difference between Unicode and ASCII code?

describe the destination index


What is the difference between viscosity and viscosity index?

Viscosity is resistance to flow of oil Viscosity Index is a scale to measure viscosity


What is the difference between a glossary and index?

A glossary defines words, while the index tells what pages certain topics are on in the book.


Difference between Index File and Index Sequential file?

index file is organized with the help of any key as index number at rondomly but index sequencial file organized with the help of any index sequentialy rajesh patel


The lack of Precambrian index fossils is the primary reason that?

correlation between rock units is impossible


What is the difference between mutual funds and index funds?

Index funds are a type of mutual fund that invests in the stocks of a specific market index, attempting to maintain a value per unit that tracks that index.


What is the difference between an index one crime and an index two crime as measured in the Uniform Crime Reports of the FBI?

any type of crime


What is the difference between male and female body mass index?

There are boys and girls. They are different