Keywords in Default Values

The default values of columns with a string data type, are automatically quoted in DeZign for Databases when you generate the physical database. When your default value contains a keyword such as CURRENT_DATE, CURRENT_TIME, NULL or another reserved word, the default value will be quoted also. You can avoid this by enclosing the default value with square brackets ([ ]).


Learn Get products and technologies
  • Build your next data model with DeZign for Databases trial software, available for download directly from Datanamic's download section.