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.

 

Name

Enter a name for the new default, or modify the name of the default being edited.

 

Schema

Use the drop-down list to select the schema to which the default belongs.

 

Default Editor - Editing default definition

 

 

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.