what is the meaning of the Constraint in the following.

Question

0.00/5 (No votes)

See more:

Hi Team,
I have the following SQL information which i am not getting understand..

SQL

Constraint_Type     Constraint_Name                  Constraint_Keys
1   FOREIGN KEY   FK_K2ZTECFRDAILY_K2CFRMASTER     CFRMASTERID REFERENCES KAIZEN.dbo.K2CFRMASTER (ID)
3   FOREIGN KEY   FK_K2ZTECFRDAILY_K2FILELOG       FILELOGID REFERENCES KAIZEN.dbo.K2FILELOG (ID)
5   FOREIGN KEY   FK_K2ZTECFRDAILY_K2FILELOGID     FILELOGID REFERENCES KAIZEN.dbo.K2FILELOG (ID)

Please anybody can explain me the above process .What does it mean ?? for which column have set the foreign key?? How it works??.As I am new for this .please let me know.

Thanks
Harshal

Posted 27-Apr-14 22:19pm

R Harshal

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

King Fisher · Answer 1 · 2014-04-27T23:03:00

Solution 1

Read it:
FOREIGN KEY - Ensure the referential integrity of the data in one table to match values in another table

http://www.w3schools.com/sql/sql_constraints.asp[^]

Posted 27-Apr-14 23:03pm

King Fisher

Updated 27-Apr-14 23:04pm

v2

Comments

[no name] 28-Apr-14 5:15am

I got your point King_Fisher But how to identify for which column foreign key was set in Constraint_Keys Column in the above information??

[no name] 28-Apr-14 5:41am

Thank you so much .I got the constraint list from my manager, it get solved.

RahulMGunjal · Answer 2 · 2014-04-28T01:02:00

Solution 2

For the first example

CFRMASTERID of current table is defined as foreign key having constraint name as FK_K2ZTECFRDAILY_K2CFRMASTER which is present in K2CFRMASTER Table of KAIZEN database having column name as ID.

Posted 28-Apr-14 1:02am

RahulMGunjal

Comments

[no name] 30-Apr-14 5:25am

ohh . i got it
Thank you so much Rahul Gunjal.