With Toad Data Modeler 5.4, in a model for SQL Server 2014, I’ve specified the “GETDATE()” T-SQL function as a default for a table column. Naturally, the following code is generated for that column in the create table statement:
, [Created_Date] Datetime DEFAULT GETDATE() NOT NULL
I would prefer the constraint be created with a name, inline if required, such as:
, [Created_Date] Datetime NOT NULL CONSTRAINT df_Created_Date DEFAULT GETDATE()
Is there some way to make this happen? Our DBA despises auto-generated object names.