7dAw4d2J

1select * from sysobjects where xtype='U' and name ='tablename'
2	
3CREATE TABLE IF NOT EXISTS myTable (
4    ....
5)
6	
7select count(*) from my_tables where table_name='table_1'; 
8If count>0 then  ...
9	
10select * from user_tables where table_name = 'tablename';