When you complete the schema for the new (or modified) table, select the Exit option on the CREATE TABLE (or ALTER TABLE) menu. DB–Access displays the menu, as Figure 53 shows.
CREATE TABLE clients: Build-new-table Discard-new-table Builds a new table and returns to the Table Menu. ----- Page 1 of 1 ---- mydata@mydbserv --------- Press CTRL-W for Help ---- Column Name Type Length Index Nulls customer_num Serial 101 Unique No fname Char 15 Yes lname Char 15 Yes company Char 20 Yes address1 Char 20 Yes address2 Char 20 Yes city Char 15 Yes state Char 2 Yes zipcode Char 5 Dups Yes phone Char 18 Yes
To create the table that contains the displayed columns and return to the TABLE menu, select Build-new-table. To return to the TABLE menu without saving the new or modified table definition, select Discard-new-table.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]