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.

Our knowledge base is currently being reorganised: if you do not find the information you are looking for please try the following options:

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.