answersLogoWhite

0

It is a contraint(checks) provided by DBMS. if we want to make a coumn unique and not null then the column is defined as primary key. it is used to create relations among the tables.

For any further detail, please visit the following links:http://www.iyogibusiness.com

User Avatar

Wiki User

16y ago

What else can I help you with?

Related Questions

Which field MS Access will not allow you to delete?

A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.


Can super key be as primary key?

I think super key is treated as the primary key because in a table their will be only one primary key.


What are the importance of primary key?

Importance of primary key


What does the primary key in a data base do?

We know that primary key is the one that is not null and is always unique. A primary key uniquely identifies a record in a table.


What are the advantage of primary key?

Primary key that is used to identify a record uniquely. Primary key is a key that always unique and not null. A system generated primary key is called surrogate key.Primary key is the one which is always unique and not null. Advantage of primary key that it helps in identifying a tuple uniquely.


What is the primary key for the properties table?

Primary key is to set property ID as the primary key for the properties table.


What is a Primary key in relation to functions and relations?

A primary key is the identifier in a table. It cannot contain values that are null, and it has to be unique for every record. For example, a driver's license number could be a primary key in a relational database table. Every driver is assigned to one unique identifier, or driver's license number, and no two driver's license numbers are identical.


How you create or assign primary key?

A primary key is never null and is also unique . Example of primary key is create table emp (ecode integer NOT NULL PRIMARY KEY);


Why do you designate one of the candidate key of relation to be the primary key?

We designate one of the candidate key of a relation to be a primary key because that primary key is use for any foreign key references.


Candidate key and primary key differnece?

All Primary keys are definitely Candidate Keys. A Candidate key is one which can be used as a Primary key that is not null and unique. That is one of the candidate keys can be chosen as a primary key.A Candidate key is a Unique Key and it can be used to find out any particular Tuple (row) in a table. The following are the differences between A Candidate key and a Primary Key: 1) A Unique key can be null but not a Primary key 2) On a table we can have only 1 primary key but 'N' number of unique keys.


Can a primary key refer to a whole table?

No, a primary key do not refers to the whole table .A primary key refers to a field in the table that is not null and unique.


What is A field that uniquely identifies a particular record in a table called?

A field that uniquely identifies a particular record in a table is called a primary key. The field or fields on which records are sorted is called the sort key.

Trending Questions
What causes ghost images on a LCD display This is not permanent burn-in the ghosting appears on all imagestext etc. It makes the screen appear blurry? What is a Range Extender used for? What is the halfway point between Oakland Ca and Johanseberg South Africa? How many boxes 120 centimeters long by 25 centimeters wide by 10 centimeters high fit in 1 cubic meter? What are possible reasons for why Windows 10 won't install? Why crossover configuration of unshielded twisted-pair UTP for Ethernet cable is needed in connecting 2 PCs through Ethernet interface? What is the process in which a user sends computer information from his computer to another computer through modem.? Why would a floating static route be configured with an administrative distance that is higher than the administrative distance of a dynamic routing protocol that is running on the same router? What must happen before any data can be read or written on a hard disk? Which piece of computer hardware do you think is the most useful or important to a computer? Do mice eat cereal boxes? How many ounces is 22.18 milliliters of water? What is the purpose of media access control? How do you repair an Outlook PST file? What is example single core processor? Can you press charges against a bartender for falsely adding a gratuity to your bar tab after you signed your tab? The system that provides people with information about their movements and orientation in space is called? Which utility will show you when the service was stopped as well as any error messages generated by the service? Which is not a debugging technique A.core dumps B. traces C. print statements D. regression testing? What was the purpose of the holes in colossus?