Online Documentation for SQL Manager for SQL server
Use the Default tab of Default Editor to create/edit a default and specify its definition.
Enter a name for the new default, or modify the name of the default being edited.
Use the drop-down list to select the schema to which the default belongs.
This area represents an expression that contains only constant values (it cannot include the names of any columns or other database objects). Any constant, built-in function, or mathematical expression can be used, except those containing alias data types.
The definition must conform to the following rules:
- character and date constants are enclosed in single quotation (') marks;
- monetary, integer, and floating-point constants do not require quotation marks;
- binary data must be preceded by 0x
- monetary data must be preceded by a dollar ($) sign.