--- id: post/duiliotacconi-com/2201 type: post title: Debunking Myths related to Table Structure in Dynamics 365 Business Central 2026 Wave 2 summary: This post debunks common myths about table structure limits in Dynamics 365 Business Central 2026 Wave 2 (version 29), which now merges table extension fields into base tables. It clarifies field count limits (1018 fields), SQL Server 8KB record size constraints based on data types, key/index limits (no 40-key cap), and the possibility of mixing base and extension fields in indexes. tier: community language: en tags: - table structure - field limits - indexes - table extensions - database design - sql server system: development review: state: reviewed by: opus at: "2026-10-07T23:46:09.790Z" flags: [] generated: at: "2026-10-07T22:42:12.892Z" pipeline: 0.2.0 prompts: extract-post: 1 input_hash: 909b59e549bbcf04d1efc7fc3e4a47b0c6a29f085b85dbef0310cf5016c200da evidence: - kind: blog url: https://duiliotacconi.com/2026/10/07/debunking-myths-related-to-table-structure-in-dynamics-365-business-central-2026-wave-2/ title: Debunking Myths related to Table Structure in Dynamics 365 Business Central 2026 Wave 2 date: "2026-10-07" commit: null t: null quote: null - kind: blog url: https://duiliotacconi.com/2026/10/07/debunking-myths-related-to-table-structure-in-dynamics-365-business-central-2026-wave-2/ title: Debunking Myths related to Table Structure in Dynamics 365 Business Central 2026 Wave 2 date: "2026-10-07" commit: null t: null quote: All 3rd party app fields are now part of the base table. - kind: blog url: https://duiliotacconi.com/2026/10/07/debunking-myths-related-to-table-structure-in-dynamics-365-business-central-2026-wave-2/ title: Debunking Myths related to Table Structure in Dynamics 365 Business Central 2026 Wave 2 date: "2026-10-07" commit: null t: null quote: 1024 is the maximum column definition allowed by SQL Server. - kind: blog url: https://duiliotacconi.com/2026/10/07/debunking-myths-related-to-table-structure-in-dynamics-365-business-central-2026-wave-2/ title: Debunking Myths related to Table Structure in Dynamics 365 Business Central 2026 Wave 2 date: "2026-10-07" commit: null t: null quote: Text and Code they don't. They are SQL NVARCHAR, hence their data can be of super large dimension. links: learn: [] objects: [] features: [] topics: [] localizations: [] videos: [] posts: [] guidelines: [] post_id: "2201" source_id: duiliotacconi-com source_name: Duilio Tacconi url: https://duiliotacconi.com/2026/10/07/debunking-myths-related-to-table-structure-in-dynamics-365-business-central-2026-wave-2/ published_at: "2026-10-07T13:14:06.000Z" author: Duilio Tacconi full_text: false words: 1438 quotes: - text: All 3rd party app fields are now part of the base table. why_it_matters: This is a fundamental architectural change in version 29 that affects how developers design and extend tables - text: 1024 is the maximum column definition allowed by SQL Server. why_it_matters: Understanding the SQL Server hard limit helps developers plan field counts without hitting deployment errors - text: Text and Code they don't. They are SQL NVARCHAR, hence their data can be of super large dimension. why_it_matters: Clarifies that the 8KB record limit is conditional on data type, not an absolute constraint for all fields code_objects_mentioned: [] systems: - development - platform versions_mentioned: - "29" - 2026 Wave 2 preview: embeddable: true frame_url: https://duiliotacconi.com/2026/10/07/debunking-myths-related-to-table-structure-in-dynamics-365-business-central-2026-wave-2/embed/ image: https://i0.wp.com/duiliotacconi.com/wp-content/uploads/2026/10/babayaga.png?fit=1200%2C432&ssl=1 image_alt: null image_w: 1200 image_h: 432 site_name: Dynamics 365 Business Central tales, myths, legends. And something serious. favicon: https://duiliotacconi.com/wp-content/uploads/2023/07/cropped-wordpress.png?w=32 probed_at: "2026-10-07T21:11:56.819Z" --- # Debunking Myths related to Table Structure in Dynamics 365 Business Central 2026 Wave 2 [Read the post](https://duiliotacconi.com/2026/10/07/debunking-myths-related-to-table-structure-in-dynamics-365-business-central-2026-wave-2/) · Duilio Tacconi (Duilio Tacconi, MVP) · 2026-10-07 · 1438 words · tier community · reviewed (checked by Opus) > This post debunks common myths about table structure limits in Dynamics 365 Business Central 2026 Wave 2 (version 29), which now merges table extension fields into base tables. It clarifies field count limits (1018 fields), SQL Server 8KB record size constraints based on data types, key/index limits (no 40-key cap), and the possibility of mixing base and extension fields in indexes. ## Key points - In version 29, all third-party app fields are now part of the base table with no separate table extension joins - Maximum of 1018 regular fields can be defined in a table (1024 SQL columns minus 6 system fields) - The 8KB SQL Server limit applies only to primitive data types; text and code fields use pointers and can exceed this - The 40-key limit from CSIDE no longer applies; SQL Server allows up to 999 indexes - Base table fields and extension fields can be mixed in the same index, with some constraints across different apps ## Quotes - "All 3rd party app fields are now part of the base table." (This is a fundamental architectural change in version 29 that affects how developers design and extend tables) - "1024 is the maximum column definition allowed by SQL Server." (Understanding the SQL Server hard limit helps developers plan field counts without hitting deployment errors) - "Text and Code they don't. They are SQL NVARCHAR, hence their data can be of super large dimension." (Clarifies that the 8KB record limit is conditional on data type, not an absolute constraint for all fields) ## Context - Features: table extensions, field definitions, index creation, table record sizing, field type storage - Versions: 29, 2026 Wave 2 Source: Duilio Tacconi, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.