web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Business Central Table...
Small and medium business | Business Central, N...
Unanswered

Business Central Table field default value in the SQL

(0) ShareShare
ReportReport
Posted on by Sautu 45

Hi,

I am developing a BC extension and I have added some tables and fields.

I have published the extension correctly and I have seen in the SQL that the values that I add have no "Default Value or Binding" defined in the SQL but Business Central standard fields do have it.

The system works as expected, I have not been able to see how this affects but this is something that is bugging me.

Standard table: Item

pastedimage1603373957157v1.pngpastedimage1603436270190v1.png

My table definition:

pastedimage1603374018257v2.png

Is this normal? Am I doing something wrong? Does this happen in production environments?

Does anybody know why this happens?

Kind regards,

I have the same question (0)
  • Daniel Rimmelzwaan Profile Picture
    Daniel Rimmelzwaan 3,485 on at

    It depends on the datatype. Your first example is a field of type 'Code'. I'm not sure what the (N") stands for but in BC Code type fields are always uppercase, maybe that's what the default value means.

    Your own example is an integer type field, and I suppose that does not need a value in that property on SQL Server.

    Don't worry about it though, let BC take care of that

  • Sautu Profile Picture
    Sautu 45 on at

    Thanks Daniel,

    I have checked and added a new image to the post where a standard int field shows a 0 default value for int (it's the same for all the fields I have checked).

    In SQL N means nvarchar datatype and the default value is '' (empty string different from null).

    You are right that BC takes care of that correctly, but it is starnge as I try to define fields as BC does and the result is different.

    Kind regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,744 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,068 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 596 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans