Join the social network of Tech Nerds, increase skill rank, get work, manage projects...

Difference between DELETE and TRUNCATE commands?

Delete command in SQL removes the ROW based on the condition provided with the WHERE clause, if no WHERE clause is provided it deletes all the row from the table. Syntax for delete command: DELETE FROM table_name WHERE column_name='value'...

Difference between Delete and Truncate

Following is difference between Delete and Truncate in database: Delete: DELETE is a DML(Data Manipulation Language) Command. DELETE statement is executed using a row lock, each row in the table is locked for deletion. You can add filte...
Sign In

Sign up using

Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: