Interested to Buy Any Domain ? << Click Here >> for more details...
about foregine
- 2 Answers
- 4151 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vishal
foreign key is the key reference of primary key in first
table suppose u have two table emp and dept in both there is
deptid than we make deptid in dept table as foreign key and
on we add dept in the dept table only when there is entry in
emp table and delete from emp only when there is no
corresponding entry in dept table
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / malli
foregine key is normal key of first(base) table. in
second(child)table it is primary key which is referenced by
the first(base) table.
| Is This Answer Correct ? | 1 Yes | 0 No |
What are the differences between char and varchar data types?
How to see the create table statement of an existing table?
What does tinyint mean?
What is mysql good for?
Explain MySQL optimization?
What is a trigger in mysql?
What is the difference between GROUP BY and ORDER BY in Sql?
12 Answers Creative, Renault Nissan, Trikon Networks,
what is the advantage of stored procedures, triggers and indexing in mysql
What is the use of pdo?
what is the difrence between sql and pl/sql
What is a transaction? Describe mysql transaction properties.
What is the limitation of mysql?
-
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)
