dbo.CUSTOMER Columns mo CUST_NUM (PK, int, not null) E CUST_LNAME (varchar(30), null) E CUST_FNAME (varchar(30), null) E CUST_BALANCE (decimal(9,2), nu E CUST_ DOB (date, null) Keys Constraints...

code must be in SQL SSMS format

/*29. Write a trigger to update the CUST_BALANCE ON CUSTOMER TABLE when an invoice is deleted (INV_NUM) FROM INVOICE TABLE. Name
the trigger trg_updatecustbalance2.*/

TABLE STRUCTURE IS ATTACHED

Extracted text: dbo.CUSTOMER Columns mo CUST_NUM (PK, int, not null) E CUST_LNAME (varchar(30), null) E CUST_FNAME (varchar(30), null) E CUST_BALANCE (decimal(9,2), nu E CUST_ DOB (date, null) Keys Constraints Triggers Indexes Statistics dbo.EMP_1 dbo.EMP_2 dbo.EMPLOYEE dbo.INVOICE Columns ro INV_NUM (PK, int, not null) C- CUST_NUM (FK, int, null) E INV_DATE (date, null) E INV_AMOUNT (decimal(11,2), nul Keys Constraints Triggers Indexes + Statistics dbo.JOB dbo.PROJECT Views External Resources 囲回 田田