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
)
go
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
go
create table err_cd (
err_id integer not null,
err_desc varchar(60) not null,
constraint pk_err_cd primary key clustered (err_id)
)
go
|
|