Re: sql script delete all tables

Are you allowed to drop and recreate the user? In that case, try

Drop User xyz Cascade;

and then

Create User xyz (with the regular privileges, etc.)

If not, others have suggested a script that writes another script, but I would append the word 'Cascade' to ensure all subordinate objects are also dropped.

/Hans Received on Fri Mar 21 2003 - 21:36:30 CST