delete tables

From: Lud (anonymous_at_discussions.microsoft.com)
Date: 06/02/04


Date: Wed, 2 Jun 2004 16:31:02 -0700

I´m new with SQL. I have a CA product that creates every day 44 tables, aways with the same name (RCXXXXX). But this program don´t delete this tables after generate its. I need to delete this tables automatic whent they became 7 days old. Any one can help?
Thanks,

Lud