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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

create and drop together?

Status
Not open for further replies.
bonosa

bonosa

Programmer
May 19, 2004
76
US
Is is possible to drop table if exists and create it in the same query?

Thanks,
sb
 
Sort by date Sort by votes
Does just deleting all the rows work for you?

DELETE FROM MyTable
 
Upvote 0 Downvote
That wont work since the tables have varying number of columns. But I do appreciate your help. I guess I will go with a drop query followed by a create.
Thanks,
sb
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Gerrit Broekhuis
  • Locked
  • Question
create connection by code
Replies
2
Views
301
Gerrit Broekhuis
Gerrit Broekhuis
lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
357
lupidol
lupidol
penguinspeaks
  • Locked
  • Question
Stored Procedures and triggers
Replies
9
Views
331
penguinspeaks
penguinspeaks
BobThornton
  • Locked
  • Question
Drop/Truncate tables based on a stored procedures value 1
Replies
6
Views
396
BobThornton
BobThornton
EdLentz
  • Locked
  • Question
Need to compare two tables and list the differences
Replies
3
Views
309
EdLentz
EdLentz

Part and Inventory Search

Sponsor

Back
Top