Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dasu
Posting Yak Master
104 Posts |
 Posted - 2004-10-14 : 07:14:32
|
| please suggest me the solution about reference keythe situation is like thisi have to tables1.t_cbs_rqst_dtls(err_rsn)2.t_cbs_epilkup (err_rsn) so now i did foreign key between above two fieldscan i insert null value in t_Cbs_rqst_dtls table for err_rsn field.regardsdasu.g |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-10-14 : 07:35:10
|
if t_Cbs_rqst_dtls is child then no, if it's parent then yesprovided err_rsn is the key.Go with the flow & have fun! Else fight the flow  |
 |
|
|
hgorijal
Constraint Violating Yak Guru
277 Posts |
Posted - 2004-10-14 : 07:41:27
|
| or is it the other way round !!!!Parent can't have a null in Primary key, child can have a null in foreign key. ;)Hemanth GorijalaBI Architect / DBA...Exchange a Dollar, we still have ONE each.Exchange an Idea, we have TWO each. |
|
|
|
sinapra
Starting Member
24 Posts |
Posted - 2004-10-14 : 07:47:15
|
| I think child can have null, since any child field needs reference and if if child has value and parent hs none, it returns an error.Cheers |
|
|
|
|
|
|
about foreign key