Re: How to delete a user and his table?
From: Grady Norris <grady_at_writeme.com>
Date: 26 Sep 2001 14:53:25 -0700
Message-ID: <56032ff5.0109261353.18d8554d_at_posting.google.com>
Date: 26 Sep 2001 14:53:25 -0700
Message-ID: <56032ff5.0109261353.18d8554d_at_posting.google.com>
ftp <shyan_at_cse.cuhk.edu.hk> wrote in message news:<9ot6t3$klf$1_at_eng-ser1.erg.cuhk.edu.hk>...
> drop user usernmae;
> cannot delete the user if he/she has created tables.
> How to drop the user and his/her tables?
>
> --
Add the 'cascade' option:
drop user USERNAME cascade; Received on Wed Sep 26 2001 - 23:53:25 CEST