Creating a New Table

To create a table, you must have the Resource or DBA privilege on the database.

To create a table using the Table wizard

1. Right-click the Tables folder in the Object Explorer and select New Table to launch the Create a Table dialog box.
2. Enter the table name in the Create a Table dialog box.
   Click OK to create the table.
3. Choose Table->Execute to save the table to the database.

 Tips

• The table name must be unique to objects in the database (for example, tables, views, and synonyms). If you save your table and the table name is not unique, the Table Name dialog box appears, prompting you for a new name.
• A table name must begin with a letter or underscore character; contain letters, digits, and underscore characters; have a maximum of 18 bytes for IBM Informix Dynamic Server, Version 7.x, and no spaces.