Date: Wed, 28 Jan 2009 17:04:58 +0100
"Wilfrid" <grille11_at_yahoo.com> a écrit dans le message de news: 49807732$0$10060$426a74cc_at_news.free.fr...
| There has been many communication on the exists command on newsgroups, web
| sites... but I could not find anything close to this (below) that it can be
| possible with MS SQL.
| I am migrating databases and scripts from SQL to Oracle and I am trying to
| make things as simple as possible.
| Is there a simple way with oracle that does the same thing as the script
| below in SQL?
| I am testing if the table 'tablename' exists in the schema and if no create
| IF OBJECT_ID('tablename') is null
| CREATE TABLE tablename
| id int not null,
| name nvarchar(10) null
| Thanks in advance for your help
Check if it is in user_tables
Michel Received on Wed Jan 28 2009 - 10:04:58 CST