which command will using to delete all rows from table truncate or del

ahmed salah

4y1k

I work on sql server 2017

i need to delete all rows from table student_course

but i don't know use

delete from student_course

truncate table student_course

table student_course

studentid pk

courseid pk

table student table

studentid pk

table courses

courseid pk

---------------------------------------------

student_course table have relation with courses table and student table

so which command will be used to delete all rows from table student_course

truncate or delete ?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh4y ago
You can obviously use any of them in your current case there will be no issue.

You will face issue when you will delete from student table or Course table directly, Sql server won't allow you to delete until foreign key relationship action (refrential integrity) is set to cascade or null.
Rajanikant Hawaldar4y ago
since your table having PK so use DELETE it will be faster.
Uttam Kumar4y ago
You can use either one delete or truncate. Both will delete all the data from the table.
```
Delete from student_course
Truncate table student_course
```
Upon deletion using Delete command will only delete all the data where as using Truncate command will not only delete all the data but reset the table to initial state.
Muhammad Imran Ansari4y ago
You can use either DELETE or TRUNCATE command to server the purpose.
DELETE FROM student_course
OR
TRUNCATE TABLE student_course
DELETE is use when we want to apply WHERE clause. TRUNCATE is faster and we cannot undu deleted records but in delete we can revert back.
Further, you can read the the difference between DELETE and TRUNCATE:
https://www.sqlshack.com/difference-between-sql-truncate-and-sql-delete-statements-in-sql-server/