answersLogoWhite

0

even though both these commands are related to the structure of the table...,we can regain the data when we use use drop command by use of rollback command but its not possible in the case of truncate command.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What is the difference between delete and truncate statement in SQL Database?

Delete statement deletes only the data from the table but you can apply some condition and only part of the data can be deleted. Truncate empties entire table. Drop deletes the table itself.


What are the components of oracle database?

DDL - Data Definition Language Create,Alter,Drop and Truncate are the components of oracle database.


What is the difference between a -10 and a -8 fast pitch bat?

The difference between these bats is the difference between the ratio of their weights and lengths. An example of a drop 10 bat you be on that is 33 inches in length and 23 ounces. A drop 8 bat would be 33 inches long, but weigh 25 ounces. Drop describes the ration between weight and length.


What is potential drop?

There is no difference between potential difference and potential drop. Both terms refer to the difference in voltage (i.e. potential) across a component. Depending on how you look at it, both terms can refer to positive or negative differences, i.e. drop, for instance, can be negative, implying a rise.


What is the difference between a drop kick and a punt?

A drop kick needs to hit the ground before it's kicked , where as a punt does not


What is the difference between a Easton Stealth Softball bat SCN7B and SCN6B?

SCN7B is a -9 drop SCN6B is a -10 drop


The difference in voltage between the two sides of a device is called?

Voltage drop.


What is the potential difference between 2 points in a circuit called?

Voltage drop


What is the difference between a fumble and a interception?

an interception is when you steal the ball but a fumble is when you drop it


Will view drop if table drop?

If the dropped table is a base table for a view , then dbms like oracle invalidates these dependent views but does not drop them. But you cannot use these unless you re-create the table.


What is the name of two DDL operations in SQL?

Some of the operations performed in DDL in sql are creation of table,alteration of table,truncate a table, drop a table


What is the difference between a drop in BBQ grill and a built in BBQ grill?

There is no difference between a built-in and a drop-in barbecue grill. The company who manufactures the product selects what they wish to call it. Both products require an exact measurement for installation.

Trending Questions
What percentage of teens have gonorrhea? What is the probability of a couple giving birth to five girls in a row? Your last period was 2 and a half weeks ago and it wasnt normal you have had many signs of pregnancy over the past couple weeks is there a chance that you pregnant? How many STDs are there? What is an advantage of a stem plot over a histogram? Could you use a line graph to show data? I'm 13 years old I'm 5'8 how tall am i going to be at 21? How many different numbers can you make with the digits 1 2 3 and 4 using each digit only once? Does starkly mean similar or different? What can be used to show a cause and effect between two variables? What are the least and greatest numbers round to 30000? A particular fruit's weights are normally distributed, with a mean of 298 grams and a standard deviation of 13 grams.If you pick one fruit at random, what is the probability that it will weigh between 262 grams and 269 grams? Is the amount of time sleeping discrete or continuous? Who invented probability and statistics? What is the formula for the area of the circle given the diameter? How do you find height of histogram? What does falseifiable mean? What does a 34.7 mean in MCH blood test reading? In a random sample of 144 observations the sample proportion equals 0.6 The 95 percent confidence interval for P is? Eighty percent of all California drivers wear seat belts. if three drivers are pulled over what is the probability that all would be wearing their seat belts write as a percent to the nearest ten?