Suggest an idea for a new or improved feature!

← Azure Synapse Analytics

Support for Non-deterministic expressions or functions, such as GETDATE() or CURRENT_TIMESTAMP in default constraints

108 votes

Aritra shared this idea · Jun 23, 2016 · Flag idea as inappropriate… · Admin →

under review · Jun 11, 2019

Show previous admin responses (1)

6 comments

An error occurred while saving the comment

Vishal Gupta commented · January 23, 2021 10:43 AM · Flag as inappropriate

Need this feature for lot of auditing and migration activity !!!

Submitting...
Robert Kostecki commented · January 8, 2021 9:45 AM · Flag as inappropriate

Must for any audit table ...

CREATE TABLE [Schema].[TableName]
(
[LoadTime] [datetime2] NOT NULL CONSTRAINT DF_TableName_LoadTime DEFAULT GETDATE(),
...
)

Submitting...
Jason Horner commented · December 14, 2020 7:51 AM · Flag as inappropriate

Agreed this should support functions like SYSDATETIME() and SUSER_NAME() too

Submitting...
Renata commented · November 26, 2020 12:45 AM · Flag as inappropriate

What a joke this is not available :-(

Submitting...
Anubhav Agarwal commented · October 11, 2020 11:54 AM · Flag as inappropriate

Any update on this? Need to add a default column with the current system date

Submitting...
Anonymous commented · May 24, 2018 12:59 AM · Flag as inappropriate

What can be the alternative for this if this is not supported?

Any valid timeline for this??

Submitting...

Azure Synapse Analytics: SQL/T-SQL

Searching…

No results.
Clear search results

Give feedback
- (General Feedback) 6,610 ideas
- Additional Services 325 ideas
- Analytics Platform System 20 ideas
- API Apps 0 ideas
- API Management 638 ideas
- Automation 515 ideas
- Azure Active Directory 5,041 ideas
- Azure Active Directory Application Requests 275 ideas
- Azure Advisor 32 ideas
- Azure Analysis Services 187 ideas
- Azure API for FHIR 12 ideas
- Azure App Configuration 44 ideas
- Azure Arc 27 ideas
- Azure Automanage 4 ideas
- Azure Backup 539 ideas
- Azure Blockchain Service 11 ideas
- Azure Bot Service 35 ideas
- Azure Certified Device 15 ideas
- Azure Cloud Shell 367 ideas
- Azure Cognitive Services 43 ideas
- Azure Confidential Compute 1 idea
- Azure Container Instances 165 ideas
- Azure Container Registry 97 ideas
- Azure Cosmos DB 276 ideas
- Azure CycleCloud 5 ideas
- Azure Data Explorer 209 ideas
- Azure Data Share 11 ideas
- Azure Database for MariaDB 18 ideas
- Azure Database for MySQL 72 ideas
- Azure Database for PostgreSQL 155 ideas
- Azure Database Migration Service 78 ideas
- Azure Databricks 270 ideas
- Azure Dev Spaces 10 ideas
- Azure Digital Twins 20 ideas
- Azure Event Grid 65 ideas
- Azure FarmBeats 12 ideas
- Azure Functions 235 ideas
- Azure FXT Edge Filer 0 ideas
- Azure Governance 195 ideas
- Azure HPC Cache 0 ideas
- Azure IoT (Hub, DPS, SDKs) 324 ideas
- Azure IoT Central 153 ideas
- Azure IoT Edge 87 ideas
- Azure IoT Security 0 ideas
- Azure IoT Solution Accelerators 45 ideas
- Azure Key Vault 172 ideas
- Azure Kinect DK 66 ideas
- Azure Kubernetes Service (AKS) 295 ideas
- Azure Lighthouse 30 ideas
- Azure Management Groups 23 ideas
- Azure Maps 74 ideas
- Azure Marketplace 456 ideas
- Azure Media Services 255 ideas
- Azure Migrate 61 ideas
- Azure mobile app 358 ideas
- Azure Monitor 251 ideas
- Azure Monitor- Alert Management 157 ideas
- Azure Monitor-Application Insights 793 ideas
- Azure Monitor-Log Analytics 995 ideas
- Azure NetApp Files (ANF) 31 ideas
- Azure Pack 297 ideas
- Azure portal 2,193 ideas
- Azure Purview 157 ideas
- Azure Quantum 0 ideas
- Azure Red Hat OpenShift 12 ideas
- Azure Remote Rendering 10 ideas
- Azure Reservations 182 ideas
- Azure Resource Manager 555 ideas
- Azure Search 288 ideas
- Azure Security Center 309 ideas
- Azure Sentinel 116 ideas
- Azure Service Health 41 ideas
- Azure SignalR Service 17 ideas
- Azure Spatial Anchors 30 ideas
- Azure Sphere 82 ideas
- Azure Spring Cloud 3 ideas
- Azure Stack HCI 7 ideas
- Azure Stack Hub 202 ideas
- Azure Synapse Analytics 456 ideas
- Azure TCO Calculator 30 ideas
- Azure Time Series Insights 30 ideas
- Batch 36 ideas
- Batch AI 10 ideas
- Biztalk Services 14 ideas
- Blockchain 55 ideas
- Cache 41 ideas
- Change Tracking 12 ideas
- Cloud Services (Web and Worker Role) 272 ideas
- Cost Management 340 ideas
- Cross region move for Azure resources 11 ideas
- Customer Insights 13 ideas
- Customer Lockbox for Microsoft Azure 1 idea
- Data Catalog 178 ideas
- Data Factory 1,216 ideas
- Data Lake 355 ideas
- Data Science VM 24 ideas
- Diagnostics and Monitoring 202 ideas
- Event Hubs 42 ideas
- Global Infrastructure 44 ideas
- HDInsight 133 ideas
- Lab Services 374 ideas
- Logic Apps 1,825 ideas
- Machine Learning 231 ideas
- Mobile Engagement 19 ideas
- Networking 1,434 ideas
- Notification Hubs 36 ideas
- Project Bonsai 29 ideas
- Scheduler 43 ideas
- Scripting and Command Line Tools 102 ideas
- SDK and Tools 148 ideas
- Security and Compliance 104 ideas
- Service Bus 206 ideas
- Service Fabric 304 ideas
- Signup and Billing 1,780 ideas
- Site Recovery 297 ideas
- SQL Data Sync 68 ideas
- SQL Database 877 ideas
- SQL Managed Instance 153 ideas
- SQL Server 10,682 ideas
- SQL Server - Big Data Clusters 47 ideas
- Storage 1,011 ideas
- StorSimple 26 ideas
- Stream Analytics 271 ideas
- Support Feedback 276 ideas
- System Center Data Protection Manager 152 ideas
- Update Management 187 ideas
- Virtual Machines 1,693 ideas
- Web Apps 628 ideas
Microsoft Azure