Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I tell if a temp table exists before dropping

Status
Not open for further replies.
martindavey

martindavey

Programmer
Jan 2, 2000
122
0
0
GB
I have tried drop table if exists myTable
but this is a syntax error.

I am using Informix.

Any ideas?
 
Sort by date Sort by votes
Hiya,

You should be able to do:

IF OBJECT_ID('my_table') IS NOT NULL
DROP TABLE my_table


HTH

Tim
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question
windows command in a sql script
Replies
1
Views
65
carp
carp
BobThornton
  • Locked
  • Question
Count records until a record value changes
Replies
2
Views
84
carp
carp
szeiss
  • Locked
  • Question
Need to select the one value if it exists otherwise another value
Replies
4
Views
79
szeiss
szeiss
BobThornton
  • Locked
  • Question
Cross Join in an Insert Into
Replies
1
Views
70
carp
carp
harfri
  • Locked
  • Question
Insert into a new table
Replies
0
Views
45
harfri
harfri

Part and Inventory Search

Sponsor

Back
Top