Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Azure
Blockchain
Devops
Ask a Question
What are the two commands to remove all of the data from a table? Are there any implications with the specific commands?
Home
Sql
What are the two commands to remove all of the data from a table? Are there any implications with...
+1
vote
asked
Jan 14, 2022
in
Sql
by
GeorgeBell
What are the two commands to remove all of the data from a table? Are there any implications with the specific commands?
t-sql
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Jan 14, 2022
by
GeorgeBell
TRUNCATE
removes all rows from a table. The operation cannot be rolled back and no triggers will be fired. As such, TRUCATE is faster and doesn't use as much undo space as a DELETE.
The
DELETE
command is used to remove rows from a table. A WHERE clause can be used to only remove some rows. If no WHERE condition is specified, all rows will be removed. After performing a DELETE operation you need to COMMIT or ROLLBACK the transaction to make the change permanent or to undo it. Note that this operation will cause all DELETE triggers on the table to fire.
Your comment on this answer:
Email me at this address if a comment is added after mine:
Email me if a comment is added after mine
Privacy: Your email address will only be used for sending these notifications.
Related questions
+2
votes
Q: Is it possible to import data directly from T-SQL commands without using SQL Server Integration Services? If so, what are the commands?
asked
Jan 15, 2022
in
Sql
by
GeorgeBell
t-sql
+3
votes
Q: How can you delete duplicate records in a table with no primary key?
asked
Jan 14, 2022
in
Sql
by
GeorgeBell
t-sql
+1
vote
Q: What are 5 commands that can be used to manipulate text in T-SQL code?
asked
Jan 14, 2022
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: Is there a difference between T-SQL linked server and a synonym?
asked
Jan 14, 2022
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What are bitwise operators and what is the value from a database design perspective?
asked
Jan 15, 2022
in
Sql
by
GeorgeBell
t-sql
+1
vote
Q: How would you prevent T-SQL code from running on a production SQL Server?
asked
Jan 15, 2022
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: Provide an example of Left Outer Join with Exclusions?
asked
Jan 15, 2022
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: How can you capture the length of a column when it is a Text, NText and/or Image data type?
asked
Jan 14, 2022
in
Sql
by
GeorgeBell
t-sql
0
votes
Q: what are dynamic queries in T-SQL?
asked
Dec 24, 2023
in
Sql
by
john ganales
t-sql
+2
votes
Q: What are types of XML indexes in SQL Server?
asked
Jan 15, 2022
in
Sql
by
GeorgeBell
t-sql
...