0
What is the difference between delete and truncate statement in SQL Database?
Jennyday4
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.
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
What is difference between basic command and statement?
difference between command and statement
What is the difference gwbasic commands and statements?
difference between command and statement
What is the difference between 'switch' statement and 'if' statement?
we can use switch statement in multiple time but in if statement we can not use multiple time
What is the difference between a declarative statement and an imperative statement?
In a declarative statement, you initialize the object. But in an imperative statement, you use a preexisting statement and use it.
Difference between sql and sql plus?
SQL*PLUS is a interface between user and Oracle database. It Provide an environment to use the SQL which is a query language to communicate with oracle database
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 are the difference between hierarchical database and network database?
what is the difference between hirarchical,network and relational database model?
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 a descriptive and an explanatory statement?
What is the difference between a descriptive and an explanatory statement?
What is the difference between database and datastore?
It is a collection tables that is stored in a database
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 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 record and database?
A database is composed of one or more records.
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
