The CREATE TABLE Screen

Home | Previous Page | Next Page The Table Option > Creating or Altering a Table >

The CREATE TABLE Screen

When you select the Create option on the TABLE menu, the CREATE TABLE screen appears, as Figure 43 shows.

Figure 43. The CREATE TABLE Screen

CREATE TABLE >>   
Enter the table name you wish to create with the schema editor.

---------------- mydata@mydbserv ------------- Press CTRL-W for Help ------

At the prompt, type the name of the new table and press RETURN. You can assign any name to the table, as long as you follow the syntax guidelines for naming database objects described in the IBM Informix: Guide to SQL Syntax.

After you enter the new table name, the CREATE TABLE menu appears, as Figure 44 shows.

Figure 44. The CREATE TABLE Menu

CREATE TABLE clients:   Add   Modify  Drop  Screen  Table_options Constraints Exit
Adds columns to the table above the line with the highlight.

---- Page 1 of 1 ---- mydata@mydbserv ------------ Press CTRL-W for Help -----

 Column Name                     Type           Length   Index Nulls