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 » UltraLite - Database Management and Reference » UltraLite database schemas » UltraLite tables and columns

 

Altering UltraLite column definitions

Change the structure of column definitions for a table by altering various column attributes or deleting columns entirely.

Prerequisites

The modified column definition must suit the requirements of any data already stored in the column. For example, you cannot alter a column to disallow NULL if the column already has a NULL entry.

 Task

  1. Using Sybase Central, connect to the UltraLite database.

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

  3. Double-click a table.

  4. Click the Columns tab and alter the column attributes.

  5. From the File menu, click Save Table.

Results

The table is saved with the new column attributes.

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