Interested to Buy Any Domain ? << Click Here >> for more details...
what is primary key,unique key, foreign key? can u teach me
in simple language?
- 44 Answers
- 187580 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pounammal sambath
primary key:
* primary key is the key which is used to for unique identification of the row in the table.
*it does not allows the duplicate and null values.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / 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 |
Answer / sri lekha
a key to open primary school is primary key
a key for foreign schools is foreign key
answering this way is unique
| Is This Answer Correct ? | 16 Yes | 44 No |
Answer / manmohan singh
The key to Prime Ministers office in delhi is known as
primary key. The key to Foreign Secy's cabin is foreign key.
| Is This Answer Correct ? | 114 Yes | 263 No |
Differentiate between extension & intension?
Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it
What is the difference between primary key, foreign key and candidate key?
WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?
can anyone please tell what are the roles and responsibilities of a teradata developer in detail???
What are different types of clusters present?
What is a database call?
What is the importance of database partitioning?
Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.
how to configure oracle 10g in java1.5 and tell me know how to set class path in system?
HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?
what is the full procedure for using store procedure in informatica7.1?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
