GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Tech FAQs  >  RDBMS
Go To First  |  Previous Question  |  Next Question 
 RDBMS  |  Question 17 of 18    Print  
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: 2 Last Update: August 09, 2008     Asked by: anbu 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
October 25, 2007 03:03:16   #1  
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
August 09, 2008 08:57:47   #2  
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

 Related Questions

Latest Answer : Dr. E.F. Codd, an IBM researcher, first developed the relational data model in 1970. In 1985, Dr. Codd published a list of 12 rules that concisely define an ideal relational database, which have provided a guideline for the design of all relational database ...

Latest Answer : find the rowid for the duplicate row and delete the max id no keeping the min id. thats it... ...

If we have a table which is accessed by multiple users and two or more user's are simultaniously trying to modify the table. Then what happens and how can we manage such situations?
Read Answers (3) | Asked by : techmind

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.
Read Answers (2) | Asked by : anbu

Create a query that will display the total number of employees and of that total the number who were hired in 1980, 1981, 1982, and 1983. Give appropriate column headings.
Read Answers (3) | Asked by : adnan


 Sponsored Links

 
Related Articles

ODP.NET - Retrieving Multiple Rows on to the Grid

ODP NET Retrieving Multiple Rows on to the Grid In the previous section we tried to retrieve only one row using OracleDataReader In this section we will try to retrieve more than one row or a result set and populate a DataGridView on a WinForm mosgoogle The following code lists out the details of al
 

What is Data Collection Time

Modern Relational Database Management Systems can be configured to collect data at certain events.  In a business, some of the events are sale, order, deposit, pay, request and many more. Events are really business activities in a company.  Big companies, in order to gain competiti
 

The Right Time To Make A Career Change

Changing careers is one of the most crucial stages in one’s career life. There are employees who get into the career change phase earlier than other employees. But no matter how an employee enjoys his or her current career, there would come a time that an employee would think of shifting c
 

Supply Chain Management : Just In Time

Supply Chain  Management Just In Time Introduction In the realm of supply chain management Just in time” refers to an inventory strategy that it used to improve a business’ s return on investment through a reduction of in process inventory and all related costs Just in
 

Multiple Virtual Storage (MVS)

Multiple Virtual Storage MVS First let us start with an insight to the topic Multiple Virtual Storage MVS stands for Multiple Virtual Storage and this is the technology used mainly with IBM mainframe systems MVS origin is interesting to know The first developed technology was MVT which stands for Mu
 

How To Lead In An Environment With Multiple Cultures

How To Lead In An Environment With Multiple Cultures If you wish to be the leader of a large group you will need to learn how lead people who come from cultural backgrounds which are different from your own Few modern companies can survive by working with people of one cultural group mosgoogle We li
 

The Connection of the 80/20 Principle With Time Management

The Connection of the 80 20 Principle With Time Management In the early part of the 20th century an economist named Vilfredo Pareto came up with a mathematical system that explained the unequal share of wealth in society He determined that in most societies eighty percent of the wealth is almost alw
 

The Connection Between Time and Money

The Connection Between Time and Money You have probably heard people use the statement time is money" many times While it sounds like a simple statement it is much more complex then you may think There are certain connections that time has with money but there are also some notable differ
 

The Importance Of Scheduling For Time Management

The Importance Of Scheduling For Time Management Once you have set goals to achieve something you will need to begin properly managing your time in order to work towards these goals After you have created a To Do list you will next need to create a schedule which will allow you to complete all the i
 

Activity Logs Are An Important Tool For Time Management

Activity Logs Are An Important Tool For Time Management In addition to schedules and To Do lists activity logs are very useful in helping you manage your time They allow you to systematically study the way you spend your time When most people view their information on an activity log for the first t
 





About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape