Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K 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
- 326 Dynamics CRM
- 110 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 994 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
What is max key length?
arcull
Member Posts: 191
Hi everyone. I know there are some limitations when creating keys in tables on native db, because I once encoutered a problem, when it did not let me create new secondary keys, saying that max. total length of keys is xxx bytes. So I wonder if anyone knows better about the limitations of keys, what is actual max length and how do you calculate it from field types and lenghts you put in keys. Thanks for help.
0
Comments
The max is 252 characters and 20 fields. Be careful as you need to add the primary key size to secondary key. Add up the length of each field to find the size of the key
Dynamics Nav Add-ons
http://www.simplydynamics.ie/Addons.html
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!