Our use of cookies

We use cookies to tailor your experience, gather analytics, and provide you with live assitance. By clicking "Accept" or continuing to browse our site you agree to the use of cookies. For more details please read our Cookie Policy.

Why are column default values not exported to the SQL table

If you add a column to a SharePoint list and assign a default value to it, SQList will add this column to the corresponding SQL table, but will not fill it with the default value.

The reason is that SharePoint does not fill the column in the list itself when the column is added, and SQList keeps the data in the SQL table in sync with what the list items actually contain. The default value is only applied when a list item is created or modified.

This can be seen when the new column is added to a list view; the column will display an empty value rather than the default value assigned to the column definition.