Online Documentation for SQL Manager for SQL server

Creating/editing default

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.


Default Editor - Editing default definition




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.