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,
name varchar(40),
UNIQUE(name)
);
END IF
If i have a table like the above how can i identify if the table exists or not?
Thank You.
Shavonne Wijesinghe