How Do I truncate All Tbls in a Schema?

From: Jobi <yng_Couple_at_iname.com>
Date: Fri, 26 Mar 1999 07:27:37 GMT
Message-ID: <JFGK2.5028$L66.5143_at_news.rdc1.bc.wave.home.com>

Hi,

I just can seem to figure out the SQL to Truncate all the tables that belong to a specific Schema!

IE I have one Schema : EricSchema with 50 Tables, How do I truncate them in one SQL Command? Received on Fri Mar 26 1999 - 08:27:37 CET

This message: [ Message body ]
Next message: Rod Corderey: "Re: How Do I truncate All Tbls in a Schema?"
Previous message: Gerrit-Jan Linker: "Re: Assigning NULL value in PRO*C"
Next in thread: Rod Corderey: "Re: How Do I truncate All Tbls in a Schema?"
Reply: Rod Corderey: "Re: How Do I truncate All Tbls in a Schema?"

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

Original text of this message