Database test on SQL NAV 50 SP1

PerJuhl
PerJuhl Member Posts: 55
edited 2008-06-03 in NAV/Navision Classic Client
Hi

Why is the option DB Test on "Relationship between primary and secondary key" not active on SQL ?

BR Per

Comments

  • kine
    kine Member Posts: 12,562
    Because has no meaning on MS SQL...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • PerJuhl
    PerJuhl Member Posts: 55
    kine wrote:
    Because has no meaning on MS SQL...

    Right, can you get a bit closer ?

    1. As SQL do not know the logical relations ?

    2. As relations is only known in the C/SIDE objects ?

    3. Relations is NOT is implementet as SQL relations, on SQL i NAV.

    BR Per
  • kine
    kine Member Posts: 12,562
    PerJuhl wrote:
    kine wrote:
    Because has no meaning on MS SQL...

    Right, can you get a bit closer ?

    1. As SQL do not know the logical relations ?

    2. As relations is only known in the C/SIDE objects ?

    3. Relations is NOT is implementet as SQL relations, on SQL i NAV.

    BR Per

    all of this and because there are no "primary and secondary keys" on SQL. There is only clustered index and index... and it is something different and between those there is no "realtionship" to test ;-)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.

Categories