about foregine
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 is prepared statement in mysql?
What are the different tables present in MySQL?
What is procedural api?
How to load data from a text file into a table?
How do I edit a database in mysql workbench?
How to enter numeric values as hex numbers?
How can we run batch mode in mysql?
How do I insert multiple rows in a table?
what is collation? how many types of installations in sql server?
Transactions are used to treat sets of SQL statements atomically. State Whether True or False?
How can you retrieve a portion of any column value by using a select query?
What is text?
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)