Re: simple SQL Question

You can check if a table exists with :
  SELECT * FROM USER_TABLES WHERE TABLE_NAME = UPPER(<tablename>)

Ted
On Fri, 9 Mar 2001 16:28:39 +0100, "Christian Dicke" <dicke_at_x-dot.de> wrote:

>Hello all,
>
>could anyone tell me, how to find out, if a table exists?
>I want to s.th. like this:
>
>DROP TABLE IF EXISTS <tablename>
>
>Greetingz and thank you!
>Christian
>
>

EMail: knijff_at_bigfoot.com Received on Fri Mar 09 2001 - 11:28:25 CST