hi all,
i have a test db set up and have dummy data in tables
that restrict deletes. i want to delete that dummy
data. i had this problem yesterday and, found a sql
statement to do it and everything was dandy.
not being too smart yesterday, i didn't save that sql
statement and i can't find it again today.
i thought is looked like...
DELETE FROM tablename WHERE constraint CASCADE;
i also tried...
DELETE FROM tablename WHERE constraint ON DELETE
CASCADE;
no luck.
any guidance here would be appreciated. tia...
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com