what is for foreign key ??
Answers were Sorted based on User's Feedback
Answer / akhtar mohammad kalim
A foreign key is a field (or fields) that points to the
primary key of another table. The purpose of the foreign
key is to ensure referential integrity of the data. In
other words, only values that are supposed to appear in the
database are permitted.
For example, say we have two tables, a CUSTOMER table that
includes all customer data, and an ORDERS table that
includes all customer orders. The constraint here is that
all orders must be associated with a customer that is
already in the CUSTOMER table. In this case, we will place
a foreign key on the ORDERS table and have it relate to the
primary key of the CUSTOMER table. This way, we can ensure
that all orders in the ORDERS table are related to a
customer in the CUSTOMER table. In other words, the ORDERS
table cannot contain information on a customer that is not
in the CUSTOMER table.
The structure of these two tables will be as follows:
Table CUSTOMER column name characteristic
SID Primary Key
Last_Name
First_Name
Table ORDERS column name characteristic
Order_ID Primary Key
Order_Date
Customer_SID Foreign Key
Amount
In the above example, the Customer_SID column in the ORDERS
table is a foreign key pointing to the SID column in the
CUSTOMER table.
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / amit kumar
Follow this lick to get answer....
http://msdn.microsoft.com/en-us/library/aa933117.aspx
http://www.1keydata.com/sql/sql-foreign-key.html
thx
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / a.ganesh
it's reduce the repeated data in the database
.I think this is main advantage and the recode can't
directly delete from Parent Table
| Is This Answer Correct ? | 0 Yes | 0 No |
What is an etl file?
is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?
What is partition index in sql server?
What do I need to start working with sql studio? : sql server management studio
How many full-text indexes can a table have?
can you any body tell me which service pack is installed in the sql server?
What are the new security features added in sql server 2012? : sql server security
How to start and end transact-sql statements?
What is an execution plan? When would you use it? How would you view the execution plan?
What are the different types of replication are there in sql server 2000?
what is a mixed extent? : Sql server administration
What is a join in sql?
Oracle (3253)
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)