CONSTRAINT of current_timestamp generates code that will not run in SQL
tsql source has line:
[CreateDate] datetime default CURRENTTIMESTAMP,
the script that is generated:
ALTER TABLE [dbo].[AirFlowData] ADD CONSTRAINT [DFAirFlowDaCreat82DA8F3] DEFAULT (currenttimestamp()) FOR [CreateDate]
Error executing script:
Incorrect syntax near '('.
1
vote
Doug Yoder
shared this idea