Define MSSQL

SQL Data Types

SQL Commands

SQL Create Database

SQL Create Table

SQL Insert Into

SQL Select Query

SQL Orderby

SQL Update Command

Truncate Delete Drop

SQL Select Top

SQL Constraints

SQL Alias

SQL Joins

SQL Union, intersect

SQL Select Into

SQL Insert Into Select

SQL Indexes

SQL Alter Table

SQL AutoIncrement

SQL View

SQL Date Functions


SQL Aggregate Functions

SQL Group By

SQL Scalar functions

Stored Procedure

MS-SQL Truncate, Delete, Drop

The TRUNCATE command is use to removes all rows from a table.
Truncate table [table_name]

The DELETE statement is used to delete rows in a table.
Delete from customer where name = 'Ramesh' and address = 'Ahmedabad'
Delete From customer //Delete All Records

The DROP TABLE statement is used to delete a table.
DROP TABLE table_name
The DROP DATABASE statement is used to delete a database.
DROP DATABASE database_name

Difference between Delete, Truncate and Drop

The DELETE command is used to remove rows from a table, WHERE clause can be used to remove specified 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.

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 DROP command removes a table from the database. All the tables' rows, indexes and privileges will also be removed. No DML triggers will be fired. The operation cannot be rolled back.