Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 22561 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / nadiya
TRUNCATE DELETE DIFFERENCE
Truncate command will delete all records and the most
important thing to make note of
truncate command is since truncate command cannot be rolled
back one must make
sure to take proper backup of table data before performing
the truncate command.
Truncate command is thus used to remove all rows from
either a table or a cluster.
If one wants to use the truncatecommand in a cluster they
can use
it only in an indexed cluster and not in a hash cluster.
Though the functionality of delete and truncate looks on
the outward same
the main differences between truncate and delete statements
are
truncate is a DDL statement whereas
delete is a DML statement.
Truncate command cannot be rolled back but
delete command can be rolled back.
As a result, as explained
before truncate command is faster than delete command.
Another main difference between delete andtruncate command
is
delete command can be used with a where clause to delete
specific rows from a table.
If the where clause is not specified in a delete
statement,
all rows are deleted from the table.
Thus delete command can be used to delete specific or all
rows from a table.
But truncate command deletes all rows from the table.
The general syntax of truncate command is
TRUNCATE TABLE tablename;
For instance if one wished to truncate a table named as
exforsys
it is done by using the command as follows:
TRUNCATE TABLE exforsys;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
what is the difference between a primary key and a unique key? : Sql server database administration
Where to find ntwdblib.dll version 2000.80.194.0?
How do I create a partition table in sql server?
What is meant by dirty read?
Does a specific recovery model need to be used for a replicated database? : sql server replication
Does hive support indexing?
Explain what are sparse columns?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
How many categories of data types used by sql server?
Can a rule be bound to any column of any data type?
Where the sql logs gets stored?
What is table join?
List the various tools available for performance tuning?
Explain Geometry datatype in sql server 2008 with example
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
