answersLogoWhite

0

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.

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

What is the difference between truncate and delete in terms of a database transaction?

Once data is truncated it can not be rolled back (recovered). However, data can be rolled back if deleted accidentally.


What is Difference between real time database and simple database?

the difference is about the transactions. the normal database is not included deadline, but the real time database is.


What is difference between basic command and statement?

difference between command and statement


What is the difference between alter session and alter system?

Use the ALTER SESSION statement to specify or modify any of the conditions or parameters that affect your connection to the database. The statement stays in effect until you disconnect from the database. Use the ALTER SYSTEM statement to dynamically alter your Oracle instance. The settings stay in effect as long as the database is mounted. Ankit Kapse


What is the difference between database and database administrator?

Database is the data stored in the server and Database administrator is the person who designs the database.


What are difference between cache database and sql database?

CACHE is multidimensional and postconsonantal database and its supporting scripting


What is the difference between bar scale and statement scale?

What is the difference between a bar scale and a statement scale


What is the difference between drop and truncate in dbms?

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.


What is the difference between database management and documents management systems?

differences between document management and database technology


What is the difference between a database management system and a database?

DBMS: Set of software applications combined w/ a database


What is the Difference between manual database and electronic database?

A manual database is MANUAL and an electronic is electronic LOL! Simple :P


What iis difference between dbms and tfs?

database approach