1
It would be nice to have a property on a table field which defines the default clause on the SQL table, now 'empty' values are used as default values. This enables more metadata driven development, so no need for coding anymore.
for example now it's generating
ALTER TABLE [dbo].[CUSTGROUP] ADD DEFAULT ((0)) FOR [BANKCUSTPAYMIDTABLE]
or
ALTER TABLE [dbo].[CUSTGROUP] ADD DEFAULT ('') FOR [CLEARINGPERIOD]
or
ALTER TABLE [dbo].[CUSTINVOICETABLE] ADD DEFAULT ('1900-01-01 00:00:00.000') FOR [CORRECTEDINVOICEDATE_RU]
It would be nice to have an influence on that default clause. For example changing the default value for a date to current date or so.
for example now it's generating
ALTER TABLE [dbo].[CUSTGROUP] ADD DEFAULT ((0)) FOR [BANKCUSTPAYMIDTABLE]
or
ALTER TABLE [dbo].[CUSTGROUP] ADD DEFAULT ('') FOR [CLEARINGPERIOD]
or
ALTER TABLE [dbo].[CUSTINVOICETABLE] ADD DEFAULT ('1900-01-01 00:00:00.000') FOR [CORRECTEDINVOICEDATE_RU]
It would be nice to have an influence on that default clause. For example changing the default value for a date to current date or so.
STATUS DETAILS
Needs Votes