Entering Column Default Values

When you create a table or a temporary table, you can specify column default values.

1. From the Columns page in the New Table or New Global Temporary Table wizard, double-click a cell in the Default column.
2. Specify the following options:

   Option	Description
   No Default Value or Computed Value	If the column does not have a default value, this option is selected.
   Default Value	If this column has a default value, this option is selected. The default value of a column in Sybase IQ can be DEFAULT AUTOINCREMENT or IDENTITY. The value of the DEFAULT AUTOINCREMENT column uniquely identifies every row in a table.
   User Defined	If the default value is user-defined, this option is selected.
   Literal String	If the default value is a literal string, this option is selected.
   System Sefined	If the default value is system defined, this value is selected and listed in the field.
   Partition Size	If the default value is GLOBAL AUTOINCREMENT, the partition size is displayed.
   Computed Value	If the default value is a computed value, this option is selected.

3. Click OK.

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com