[SQL] Create Table Problem

[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,
        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