Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 306 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Database test on SQL NAV 50 SP1
PerJuhl
Member Posts: 55
Hi
Why is the option DB Test on "Relationship between primary and secondary key" not active on SQL ?
BR Per
Why is the option DB Test on "Relationship between primary and secondary key" not active on SQL ?
BR Per
0
Comments
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
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 ;-)
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.