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.
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
What is the means drop command in sql?
The DROP command allows you to delete things such as tables or indexes.
What is the means drop command?
The DROP table command of SQL lets you drop a table from database . The database requires you to empty a table before you eliminate from the database. But there is a condition for dropping a table ; it must be an empty table. syntax: 1st - delete from table-name; 2nd- drop table table-name;
What is 1 percent chance of drop rate in aqw?
It means that the drop has a low chance of dropping. A 1% chance means that you, on average, would be expected to receive the drop once every 100 times you defeat the monster. Of course, this can be rather annoying when the monster in question is a boss with high health/damage.
What is the drop rate of the inquisitor guard armor in AQWorlds?
10%
What does a drop in the bucket mean?
a little thing in a big picture
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 is difference between melting point and drop melting point?
No basic Difference between melting point and Drop point.
What is the main difference between a cloud drop and a rain drop?
Size.
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 cliff and a bluff?
A cliff is a steep rock face, often overlooking a body of water, while a bluff is a broad, steeply inclined hill or promontory. Cliffs are typically taller and more sheer than bluffs, which are more gently sloping. Both geological formations are commonly found in coastal areas.
What is the difference between a Easton Stealth Softball bat SCN7B and SCN6B?
SCN7B is a -9 drop SCN6B is a -10 drop
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 fumble and a interception?
an interception is when you steal the ball but a fumble is when you drop it
What is the potential difference between 2 points in a circuit called?
Voltage drop
The difference in voltage between the two sides of a device is called?
Voltage drop.
