How to drop all views or tables?

From: Un Fu <un_at_gdstech.grumman.com>
Date: Tue, 27 Oct 1992 19:34:08 GMT
Message-ID: <1992Oct27.193408.5234_at_gdstech.grumman.com>

Does anyone know how to drop all views or tables belong to a particular user by the particular user (say me)? The 'DROP VIEW ...' and 'DROP TABLE ...' commands can only remove one view or one table at a time.

Thanks in advance for any help!

-- 


****************************************************************************

Un Un Fu                                    Internet: un_at_gdstech.grumman.com
Disclaimer: I am solely responsible for what I am saying here!


****************************************************************************

Received on Tue Oct 27 1992 - 20:34:08 CET

This message: [ Message body ]
Next message: Terry Ball: "dd backup of databases on a raw device"
Previous message: Kenny Lopez - Silicon Valley EDA District Sales Rep: "How to Get From Sequent to Sun"
Next in thread: Marek Pytlik: "Re: How to drop all views or tables?"
Reply: Jack G. Jolly: "Re: How to drop all views or tables?"
Reply: hatzinger_m_at_bmwf1f.bmwf.gv.at: "Re: How to drop all views or tables?"
Reply: Albert L. Evans, IV: "Re: How to drop all views or tables?"
Reply: Marek Pytlik: "Re: How to drop all views or tables?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message