Check if table exists

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
On my website, the user can create tables, but how do i check if the table
exists, and if it doesn't  it creates the table?

Kathryn (Fire Juggler)

Re: Check if table exists

Fire Juggler wrote:
Quoted text here. Click to load it

I don't know about other DD's but in MySQL:

IF NOT EXISTS -  see the page on CREATE TABLE syntax in the MySQL manual:

Tony Garcia
Web Right! Development
Riverside, CA

Site Timeline