Answers for "foreign key not null sql"

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