Creating a Sybase table

At the end of each command press the space-bar or press enter before continuing the next step.

To create a new table:

1. Type:

       create table

2. Type a new table name.
3. A table needs to have its columns defined, so that's the next step. The column definitions start with an open parenthesis and end with a close parenthesis. Each column has a unique name and a datatype. Start the column section by typing:

           (

4. Type a column name.
5. Type a space.
6. Type the datatype (such as integer or char(3)).
7. For each subsequent column, type a comma, then another column name and datatype pair. (See `What is a Sybase datatype?' for more on data types.)
8. Finish the column section by typing:

           )

9. To set up the table, type:

           go

10. Press Enter.

If everything goes well, you see the database prompt (a period, the name of the database you are using, another period, the number one and then the greater than symbol).

Last updated: 1997/06/25 19:21:17 UT
URL: http://www.nmt.edu/tcc/help/db/sybase/table_create.html