Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Data integrity » Column defaults » Alteration of column defaults

 

Working with column defaults

You can add, alter, and drop column defaults in Sybase Central using the Value tab of the Column Properties window.

Prerequisites

You must be the owner of the table the column belongs to, or have one of the following privileges:

  • ALTER privilege on the table
  • ALTER ANY TABLE system privilege
  • ALTER ANY OBJECT system privilege
 Task

  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. In the left pane, double-click Tables.

  3. Double-click the table.

  4. Click the Columns tab.

  5. Right-click the column and click Properties.

  6. Click the Value tab.

  7. Alter the column defaults as needed.

Results

The column properties are altered.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0