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

 

Adding a column to an UltraLite table

Columns can be added to an UltraLite table after it has been created.

Prerequisites

If the table already holds data, you can only add a column if the column definition includes a default value or allows NULL values.

 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, right-click the white space below the table and click New » Column.

  5. Set the attributes for the new column and then save your changes.

Results

The column is added to the table.

 See also