Re: [SQL] Create Table Problem

2008-06-13 Thread Volkan YAZICI
"Shavonne Marietta Wijesinghe" <[EMAIL PROTECTED]> writes: > IF (table not found) THEN > CREATE TABLE distributors ( > did integer, > namevarchar(40), > UNIQUE(name) > ); > END IF Assuming you're in a procedure (above code snippet looks to be executed within

[SQL] Create Table Problem

2008-06-13 Thread Shavonne Marietta Wijesinghe
Hello I'm having some trouble checking if a table exist before i create it. Example: SELECT * FROM distributors IF (table not found) THEN CREATE TABLE distributors ( did integer, namevarchar(40), UNIQUE(name) ); END IF If i have a table like the above h