Interested to Buy Any Domain ? << Click Here >> for more details...
IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A
SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.
- 10 Answers
- 18084 Views
- I also Faced
- E-Mail Answers
Answer Posted / ram
Primary key
============
1. A table should have only one primary key
2. More than one column can consist of a primary key – upto
64 columns
3. Can not be NULL values (missing values)
4. Should be unique values (no duplicate value)
Foreign key
============
1. A table may have zero or more than that upto 32 keys
2. More than one column can consist a primary key – upto 64
columns
3. Can have NULL values
4. Can have duplicate values
5. There should be a corresponding primary key in the
parent table to enforce referential integrity for a foreign
key
| Is This Answer Correct ? | 16 Yes | 1 No |
Post New Answer View All Answers
what is sysdba and sysdbc ? which has high priority ?
What is dimensional modeling?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What are the multiload utility limitations?
What is oltp?
What do you mean by teradata intellicloud?
What are the different table types supported by teradata?
What is meant by a Clique?
How to view every column and the columns contained in indexes in teradata?
What is a clique?
What is a sparse index?
What do you mean by fastexport in teradata?
What are default access rights in teradata?
What is a dimension table?
In general, how do you optimze any sql in teradata?
