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

Example of Sybase table creation

Tech Computer Center logo

For example, to create a rolodex type table, type:

         Create table Rolodex (
             First_name varchar(40),
             Last_name varchar(40),
             Address text,
             City varchar(40),
             State char(2),
             Zip varchar(10),
             Phone varchar(15))
         go

If you see

         Msg 2714, Level 16, State 1
         Server '', Line 1
         There is already an object named 'rolodex' in the database.
then you already have a table by that name. You will have to re-type your command with a new table name.

If you see

         Msg 173, Level 15, State 1
         Server '', Line 1
         The definition for column 'Phone' must include a datatype.
you may have mis-typed you column datatype, or left it out entirely. Re-type your command, making sure that each column has a datatype defined.
Next: Deleting a Sybase table
See also: Using Sybase tables
Previous: Creating a Sybase table
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/23 21:25:11 UT
URL: http://www.nmt.edu/tcc/help/db/sybase/table_example.html
QR two-dimensional bar code