answersLogoWhite

0


Top Answer
User Avatar
Wiki User
Answered 2009-04-02 05:57:47

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

001
๐Ÿ™
0
๐Ÿคจ
0
๐Ÿ˜ฎ
0
๐Ÿ˜‚
0
User Avatar

Your Answer

Loading...

Still have questions?

Related Questions

Similarities between primary and secondary research?

what is the similarities between primary and secondary data


What the differences between primary key and foreign key?

A primary key is a special case of unique keys which doesnt accept duplicates. The difference between unique keys is that "NOT NULL" constraint is not automatically enforced, while for primary keys it is mandatoryUnique keys and primary keys can be referenced by foreign keys


What the similarities and differences between the primary curves and secondary curves of the spinal column?

The primary curve was formed before birth but the secondary curve was formed after birth. Thats basically the difference between the two. hope that helps


What is the difference between primary and secondary vitamin deficiency?

what is the difference between primary and seconday vitamin deficiency


Similarities between primary and secondary immune response?

Well...


Identify the difference between primary sector and secondary?

Identify the difference between primary sector and secondary sector


What is the difference between primary and modal auxiliary verbs?

difference between primary auxiliary verbs and modal verbs


What is the difference between primary and secondary succesion?

the difference between primary and secondary succession is that primary succession is the wipeout of something and then secondary succession is the regrowth.


Difference between foreign key and composite key?

Composite Key is made from two or more field. So a composite key can be a primary key or a foreign key. A foreign Key is the key referencing to a different table.


Explain the difference between primary and secondary storage?

The difference between primary and secondary storage is in their state. Primary storage is temporary while secondary storage is permanent.


What is the difference between primary elections and general elections?

The difference between primary and general elections is that the general election picks the candidates on the primary ticket. Primary elections determine the winner of the office.


Difference between primary and secondary needs?

what is the difference beween primary and secondary needs


The difference between primary and secondary reserves?

what are the diffrence between primary reserve and secondary reserve?


What are the similarities between database and file based system?

The similarities are: Database schema may be similar (Primary keys, foreign keys and indexes etc) SQL (Structures query language is also similar in a way) Referential integrity is also similar to a great extend)


What is the difference between primary data and secondary data Don't make it complicated please?

The difference between primary data and secondary data is that primary data is the information from the original research.


What is the difference between selling points and benefits?

what is the primary difference between selling points and benefits


What are the similarities between secondary memory and primary memory pdf?

They are both storage devices


What is the primary difference between a chemical bond and an attraction between two molecules?

The primary difference is a chemical bond is many times stronger than a attraction between molecules.


Examples of primary source?

Whats the difference between Primary and secondary sources


What is difference between primary key and foreign key?

A primary key is an attribute (or combination of attributes) that uniquely identifies each row in a relation. A primary key is designated by underlining the attribute name. The primary key of an entity set allows us to distinguish among the various entities of the set. A foreign key is an attribute in a relation of database that serves as the primary key of another relation in the same database.


What is the difference between tuberculosis and primary complex?

spelling


What is the difference between primary and secodary research?

secondary


What was a primary difference between the nwp and the nawsa?

their strategies


What is the primary difference between virus and worm?

dsdfsdf


What is the difference between primary and secondary cell?

Primary can't be recharged, secondary can be recharged.