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.


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.

  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.


The table is saved with the new column attributes.

 See also