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

Question

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

or

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 ?

Uttam Kumar · Answer

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.

Sachin Singh · Answer

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 Hawaldar · Answer

since your table having PK so use DELETE it will be faster.

Muhammad Imran Ansari · Answer

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/