Default Value for Columns are not working

Hi All,

In MySQL/MariaDB, we have an option to default the column value while creating a table(For Example createdBy: System; createdOn: CURRENT_TIMESTAMP). In Appian, if we set those values to NULL and pass them to DB, those default values get initialized and stored in the appropriate table. This works fine in MySQL and MariaDB

However, Whilst tries the same in SQL Server, I don't see that the default values get triggered and stored into the fields. Should I add anything else for SQL Server DB? Did anyone face this issue before?

Note: I don't want to set the values in Appian and store them in DB. Instead, I need to handle it DB end.

Thanks in advance.

  Discussion posts and replies are publicly visible