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

---

Resources

Learn

• DeZign for Databases: Learn more about DeZign for Databases.
• Getting started with DeZign for Databases: Start making a data model directly.
• Display data types in a diagram: Learn how to display data type and/or domain info in the entity boxes on your diagram.

Get products and technologies

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