/ ITC Help System
/ Site map
/ NM Tech homepage
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:
- Type a new table name.
- 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:
- Type a column name.
- Type a space.
- Type the datatype (such as integer or char(3)).
- 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.)
- Finish the column section by typing:
- To set up the table, type:
- 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?
to help pages
New Mexico Tech Information Technology and Communications: Help System
To report a problem: File a ticket
Send mail to the User consultant
on duty or call them at 575-835-5437
About New Mexico Tech
Maintained by John Shipman, email@example.com;
original by Steve Anderson
Last updated: 1997/06/25 19:21:17 UT