Cascade DELETE

Hi,

Tables EMP(DEPTNO,DNAME) and DEPT(DEPTNO,ENAME) with the column EMP.DEPTNO referencing DEPT.DEPTNO.

Is it possible, in one SQL statment, to delete rows from the child table when i delete the referenced row in the parent table? I´m searching an alternative to triggers.Which is the best choice?

Thanks
Miguel Received on Thu Jan 29 1998 - 00:00:00 CST