Next / Previous / Index / ITC Help System / Publications / Site map / NM Tech homepage

Creating a Sybase table

Tech Computer Center logo

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).


Next: Example of Sybase table creation
See also: Using Sybase tables
Previous: What is a Sybase datatype?
Site map
Index: Keyword index to help pages
Help: New Mexico Tech Information Technology and Communications: Help System
ITC Publications
To report a problem: File a ticket
Send mail to the User consultant on duty or call them at 575-835-5437
Home: About New Mexico Tech

Maintained by John Shipman, john@nmt.edu; original by Steve Anderson
Last updated: 1997/06/25 19:21:17 UT
URL: http://www.nmt.edu/tcc/help/db/sybase/table_create.html
QR two-dimensional bar code