sql after trigger.

Question

i have the following tables in my sql - customers,products,suppliers,distributors,sales and OriginOfProducts.

i need to create a trigger for when the product stock is less than one, it should reorder.

Can someone please write out the trigger for this scenario. It will mean alot , thanks.

Answer 1

can you create a check constraint for amount in stock column ?

Answer 2

Yes you can