answersLogoWhite

0


Best Answer

possible

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Can you have more than one columns as primary key in a table?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Can you sort more than one column at a time using Excel?

No, you can sort multiple columns or rows if you hightlight a range, but all columns or rows will need to be sorted with the same criteria (e.g. lowest to highest). You can sort an entire row by clicking on the row number at the left of the screen, then sort, as desired. You also can do the same for columns by clicking on the column letter at the top of the screen.


Can you exceed 63 columns in a Word table?

No you cannot. 63 is the maximum number of columns for a table created in Word. If you require more than that, use Excel instead.


What is an the example of a composite key through the table form?

A composite key is one which includes more than one columns in the table as part of the unique identifier. For example if you create a key out of 3 columns in a table this key that gets created is a composite key.


Why you need primary key and foreign key?

In sql you use primary key more than one column in a table


Why you colour columns rather than rows in periodic table?

because of energy levels


What are the columns on the periodic table called?

http://en.wikipedia.org/wiki/Periodic_tablegroups or families are verticalA period is a horizontal row in the periodic table. Although groups are the most common way of classifying elements, there are some regions of the periodic table where the horizontal trends and similarities in properties are more significant than vertical group trends.


Does Excel has 26 columns?

No. Excel has a lot more than that. It depends on your version, but it will have at least 256 columns and up to 16,384 columns.


What is the table's primary key?

Primary key is the unique attribute among all attributes of an object, which alone is sufficient to represent a sigle entity. for example a table has columns student id, stdent name, father name, class, department etc. so here "student id" is primary key bcoz it cann't be same for two students, where other attributes like name and class can be same for more than one student. hence primary key is the attribute which represent a unique entity and is sufficient to search the tuple (row) of table having that primary key value. Firdous Anjum The Great :) COMSATS Institute of Information Technology, Lahore.


What is a compound primary key?

There are atomic and compound primary keys used to quikly find the rows of a table you are looking for. This is more than just an idex - it helps find the one row you want like finding a needle in a haystack. Atomic keys use only one column and can not be broken down - hence atomic. Compound primary keys are made up of two or more columns from the same table. For performance reassons try to use the first columns and preferably have them close together. A table can have more than one unique index but only 1 (one, uno) primary key. You can not create a primary key that uses a column from another table. So far no one has implimented functional primary keys where the primary key is the result of a function. There are encrypted primary keys. Why use a compound primary key? So you can take the key apart quickly or validate its pieces first. If you use telephone numner (555) 555-1234 as a primary key would it not be nice to know 1) the first part is a valid 3 digits area code and not 011 a country code? 2) that the next 3 digits are a valid exchange 3) that the last part is valid By keeping the parts separate you can alos do fun quiries on "How many phones are in my exchange of 555 ? How many are in my area code? How often does my exchange or phone number apprear in other states? This would be much harder to do if the primary key was stored as a single number 5555551234.


What the difference between primary key and scendary key?

A primary key is a unique identifier for a record in a database table and is used to ensure each record is uniquely identifiable. A secondary key is a key used for sorting and indexing purposes, but can have duplicate values within a table.


More than 64 columns in HTML table?

Suggested work around..... Click on message once (without opening), press "Copy into new", "New memo" and send it to your e-mail address.


There are more primary producers than there are?

primary consumers