Default objects are named values that can be assigned to columns or domains. Defaults are available for selection from the Default list on the Check Parameters tab of column and domain property sheets. Defaults are not supported by all DBMSs.
create default CITYDFLT as 'London'