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
