RDBMS - How to delete multiple tables at a time? e.g like c* means all the tables starts with c have to be d

GeekInterview.com > Tech FAQs > RDBMS

Go To First | Previous Question | Next Question

RDBMS | Question 17 of 18

How to delete multiple tables at a time? e.g like c* means all the tables starts with c have to be deleted at a time.

Total Answers and Comments: 4

Last Update: November 12, 2008 Asked by: anbu

Sponsored Links

Best Rated Answer

—

Submitted by: shravanam

There is no way to delete multiple table at a time.
You can just drop a single table at a time.

Above answer was rated as good by the following members:
dinu_26

October 25, 2007 03:03:16

shravanam

Member Since: August 2007 Contribution: 22

RE: How to delete multiple tables at a time? e.g like ...

There is no way to delete multiple table at a time.
You can just drop a single table at a time.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

August 09, 2008 08:57:47

contact2amitesh

Member Since: August 2008 Contribution: 1

RE: How to delete multiple tables at a time? e.g like c* means all the tables starts with c have to be deleted at a time.

By using lexical parameter/variable we can delete multiple tables by using same command

as example:

SQL>drop table &table_name;

Is this answer useful? Yes | No

0 1

Overall Rating: -1

November 12, 2008 02:12:20

dinu_26

Member Since: November 2008 Contribution: 5

RE: How to delete multiple tables at a time? e.g like c* means all the tables starts with c have to be deleted at a time.

There is no possible way to delete the multiple tables in a single query. You need to delete the table one by one by using

<drop table> table name

Is this answer useful? Yes | No

November 12, 2008 02:13:45

dinu_26

Member Since: November 2008 Contribution: 5

RE: How to delete multiple tables at a time? e.g like c* means all the tables starts with c have to be deleted at a time.

There is no way to delete multiple table at a time.
You can just drop a single table at a time.

Syntax:

<drop table> table name.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank