what is primary key,unique key, foreign key? can u teach me
in simple language?
Answer Posted / patel gopikumar
PRIMARY KEY : it is a key that not allow null value in database tables field....
UNIQUE KEY : it is a key that store or manage data uniquely...
FOREIGN KEY : it is key that use is...connect two fields in the different tables........with foreign key......
thnks........
s-150907-007 PATEL GOPIKUMAR
| Is This Answer Correct ? | 5 Yes | 12 No |
Post New Answer View All Answers
what is the role of auditor in auditing data oriented applications?
How many indexes can be created on a table?
Define stored procedure?
Explain natural key?
What is difference between clustered, non-clustered and unique index?
What are the advantages of normalizing a database.
Explain entity type?
How to do Stored procedure testing? Who does this testing (Developer or tester)?
Explain normalization in one line?
What the various ways to tune a teradata query
What are the most common databases?
Is storing images in a database a good idea?
Under which circumstance should you create an index on a table?
Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool
How default key is different from primary key?