Home » SQL & PL/SQL » SQL & PL/SQL » How to Delete Multiple tables in single query
How to Delete Multiple tables in single query [message #228171] Sun, 01 April 2007 23:56 Go to next message
yamini.perumalla
Messages: 3
Registered: December 2006
Location: HYDERABAD
Junior Member
Can u please tell me How to Delete Multiple tables in single query.

thank you in advance
Yamini
Re: How to Delete Multiple tables in single query [message #228173 is a reply to message #228171] Mon, 02 April 2007 00:02 Go to previous messageGo to next message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member

hi,

can you be little more clear in what you want. you want to delete multiple tables ok.

how are they related ?structured?

please provide a sample create table and insert table
that demonstrates your need.

regards,
shanth.
Re: How to Delete Multiple tables in single query [message #228175 is a reply to message #228173] Mon, 02 April 2007 00:18 Go to previous messageGo to next message
yamini.perumalla
Messages: 3
Registered: December 2006
Location: HYDERABAD
Junior Member
I have three tables EMP ,EMP1, EMP2 with same structure. Now i want to delete all these tables in single query.

[Updated on: Mon, 02 April 2007 00:18]

Report message to a moderator

Re: How to Delete Multiple tables in single query [message #228179 is a reply to message #228175] Mon, 02 April 2007 00:35 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
You can't.
Re: How to Delete Multiple tables in single query [message #228246 is a reply to message #228179] Mon, 02 April 2007 04:22 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
u may write those query in a file and say save as c:\test.txt
and run the command @c:\test.txt

Re: How to Delete Multiple tables in single query [message #228366 is a reply to message #228175] Mon, 02 April 2007 12:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What is the final purpose and why 3 deletes don't fit your goal?

Regards
Michel
Re: How to Delete Multiple tables in single query [message #228375 is a reply to message #228171] Mon, 02 April 2007 15:02 Go to previous message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
also when you say delete the three tables, do you mean DROP the tables or do you mean delete all the rows in the table?
Previous Topic: LOOP to Match a record (merged)
Next Topic: find last wedday
Goto Forum:
  


Current Time: Tue Dec 06 10:21:53 CST 2016

Total time taken to generate the page: 0.05591 seconds