Quantcast

Maximum PC

It is currently Sun Dec 21, 2014 6:35 am

All times are UTC - 8 hours




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: [SQL] - Check if Table Exists before CREATE
PostPosted: Tue Nov 02, 2004 7:24 am 
Bitchin' Fast 3D Z8000
Bitchin' Fast 3D Z8000
User avatar

Joined: Sat Jun 26, 2004 3:44 pm
Posts: 513
Location: Vancouver Island
Yeah. I want to check if the table already exists before it's created.

Any way to do this with the CREATE table command? I'm using Oracle 9i but I'd like to stay away from PL/SQL and just go with pure SQL.

I hate databases.


Top
  Profile  
 
 Post subject:
PostPosted: Tue Nov 02, 2004 4:30 pm 
In the lab!
In the lab!
User avatar

Joined: Sun Jun 06, 2004 10:47 am
Posts: 831
Location: Secret Laboratory
I don't know about oracle but in mysql you can just say

CREATE TABLE IF NOT EXISTS tbl_name (...);


Top
  Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC - 8 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group

© 2014 Future US, Inc. All rights reserved.