Answer Detail: 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.

GeekInterview.com > Tech FAQs > RDBMS

Print |

Question: 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.

August 08, 2008 08:57:47	#2
contact2amitesh	Member Since: August 2008 Total Comments: 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;