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 ([ ]).



Back to Knowledge Base DeZign for Databases