Azure Synapse Dedicated pool Error while adding Default GetDate() value to the column

Question

Hi Team

I am using Azure Synapses Dedicated pool ,I am getting error while creating table with default constraint column value GetDate()

Create table ArchiveDB.Customer
(
  CUSTOMERID BIGINT, 
  ACCOUNT_NUMBER INT, 
  CEXPIRY_DATE DATETIME, 
  CSTART_DATE DATETIME,
  CARCHIVE_DATE DATETIME DEFAULT (GetDate()) not null
);

Msg 104338, Level 16, State 1, Line 23

An expression cannot be used with a default constraint. Specify only constants for a default constraint.

Completion time: 2024-01-05T11:37:04.8314443+00:00

Answer 1

Hey,

similar thread :

https://stackoverflow.com/questions/69388865/an-expression-cannot-be-used-with-default-constraints-specify-only-constants-fo

Synapse dedicated pool doesnt support it