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.


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

correlation between rock units is impossible


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


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.


How can a Foreign Key and a Primary Key interact with each other?

In some database systems, A Foreign Key that is set on one column (the child column ) has to point to another column (the parent column ) that is indexed. The parent column could be a primary key, since a primary key creates an index. Primary keys also keep values in the parent column unique, which can ensure unique records in the parent column's table; having a unique key on the child column can further enforce unique data that links with the unique records in the parent column .


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

There are boys and girls. They are different