Interested to Buy Any Domain ? << Click Here >> for more details...
what is for foreign key ??
- 4 Answers
- 7568 Views
- CarrizalSoft Technologies, Sabic, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the types of normalization?
Difference between Logical Page and Physical Page in SSRS.
What is the simplest way to create a new database in ms sql server?
Does windows server 2016 come with sql server?
Can we linked SharePoint to a SQL database?
How do I find query history in sql server?
What are the aggregate and scalar functions?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
What options are available to audit login activity? : sql server security
Is BCNF better than 2NF & 3NF? Why?
Why truncate is ddl command?
Why use stored procedures in sql server?
What are the disadvantages of primary key and foreign key in SQL?
What are diverse clauses that form a part of sql?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
