From: douglashawthorne@yahoo.com.au   
      
   "DottingTheNet"  wrote in message   
   news:11bf8d5a.0404112139.78b6b18e@posting.google.com...   
   > i promise no more silly questions after this   
   >   
   > but how do i check if a table exists??   
   > it is my understanding that the exists can only be used in the where   
   > clause of the query.   
   > i just want s'thing simple like   
   > if exists ('test')   
   > then ---good   
   > else   
   > --create it   
   > end if;   
   > thanx in advance!!!   
      
   Check out the ALL_TABLES and USER_TABLES views in the "Database Reference"   
   manual.   
      
   Douglas Hawthorne   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)