Custom Search : Technical Guides Sybase Oracle UNIX Javascript

Technical Guides

Of Interest

Be responsible for your future
Enter the USA legally!

Visa, Green Card, Citizenship, Passport
Consultation Services

Sybase » DDL » Design »

Creating a table


Table create examples:

create table employee (
emp_id numeric(8,0) identity,
fname varchar(10) not null,
lname varchar(25) not null,
salary money not null,
dept_cd char(3) not null,
fax_no integer null
create table invoice (
invoice_id numeric(8,0) identity,
sales_rep_id numeric(8,0) not null,
date smalldatetime not null,
comment varchar(255) null )
on data_seg2

create table err_cd (
err_id integer not null,
err_desc varchar(60) not null,
constraint pk_err_cd primary key clustered (err_id)

Sybase : Related Topics

Sybase : DDL : Sybase data types
Sybase : DDL : Altering a table
Sybase : DDL : Creating an index
Sybase : DDL : Clustered vs non-clustered indexes
Sybase : DDL : Creating a constraint
Sybase : DDL : Table Partitioning
Sybase : DDL : Modifying a Colunm
Sybase : DDL : Alter a column

Sybase Web Site
Sybase iAnywhere Mobile Web Site
Oracle Enterprise Web Site

Get the latest Rocket99 news and tech tips via

Site Index About this Guide to Sybase, Oracle, and UNIX Contact Us Advertise on this site

Copyright © 2019 Stoltenbar Inc All Rights Reserved.