foreign key not null constraint
create table orders
(
ord_no numeric (5) ,
purch_amt decimal(8,2),
ord_date date,
customer_id numeric (5) ,
salesman_id numeric(5)
foreign key(salesman_id)
references salesman (salesman_id)
)
go