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


Creating UltraLite tables

You can create base tables to hold your persistent relational data.


Tables in UltraLite applications must include a primary key. Primary keys are also required during MobiLink synchronization, to associate rows in the UltraLite database with rows in the consolidated database.

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

  2. In the left pane, right-click Tables and click New » Table.

  3. In the What Do You Want To Name The New Table field, type the new table name.

  4. Click Finish.

  5. From the File menu, click Save.


The table is created. The table and any data it contains exist until you explicitly delete the data or drop the table.


Add columns or create indexes.

 See also