Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

Creating UltraLite tables

You can create new tables to hold your relational data, either with SQL statements in Interactive SQL or with Sybase Central.

In UltraLite, you can only create base tables, which you declare in order to hold persistent data. The table and its data continue to exist until you explicitly delete the data or drop the table. UltraLite does not support global temporary or declared temporary tables.

In Sybase Central, you can perform these tasks while working with a selected database.

To create an UltraLite table (Sybase Central)

1. Connect to the UltraLite database.

2. Open the Tables folder.

3. From the File menu, choose New > Table.

   The Table Creation wizard appears.

4. In the Table Creation wizard, enter a name for the new table.

5. Click Finish.

6. On the Columns tab in the right pane, add columns to the table.

7. Choose File > Save Table when finished.

In Interactive SQL, you can declare columns while creating a new table.

To create an UltraLite table (Interactive SQL)

1. Connect to the UltraLite database.

2. Execute a CREATE TABLE statement.

   Example    The following statement creates a new table to describe the various skills and professional aptitudes of employees within a company. The table has columns to hold an identifying number, a name, and a type (for example, technical or administrative) for each skill.

   CREATE TABLE Skills (
      SkillID INTEGER PRIMARY KEY,
      SkillName CHAR( 20 ) NOT NULL,
      SkillType CHAR( 20 ) NOT NULL
   )

See also

• UltraLite CREATE TABLE statement
• Adding a column to an UltraLite table