Need a SQL expert help : How to create a trigger for DELETE ???????

Hello,

How can I create a TRIGGER for DELETE a record ?

Such as, when I delete a record, it will auto copy this record to another TABLE ???

Best regards,
Eric

--

     _  |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|  _
    / ) |     Eric, Chow Hoi Ka            ICQ# : 3463514     | ( \
   / /  |                                                     |  \ \
 _( /_  | _   E-Mail : d951686_at_sftw.umac.mo                 _ |  _) )_


(((\ \> |/ )                                               ( \| </ /)))

(\\\\ \_/ /                                                 \ \_/ ////)
 \       /                                                   \        /
  \    _/     http://www.sftw.umac.mo/~d951686/               \_     /
  /   / |_____________________________________________________| \    \
 /   /                                                           \    \