Chapter 3 – SQL SERVER – Delete, Truncate and Drop SQL Table | Create New Table using existing table In Hindi

In above video you will learn following important topic

1. How to delete record from sql table?
2. how to delete conditional record from table in sql server?
3. what is truncate command and its work?
4. what is the use of Drop command in sql server?
5. What is the difference between delete, truncate and drop command?
6. how to create new table using existing table with of without data?

Delete Table: DELETE statement is used to delete rows from a table. If we want to remove only specific row then we can use. WHERE condition Syntax:

Delete From Table_Name [Where Condition]

Example:

Delete From Employee Where EmployeeCode=‘E1001’

Delete From Employee

Truncate Table: TRUNCATE statement is used to delete all rows from table, it is very much similar to Delete Statement with no where clause. Truncate statement reset Identity column value. And Truncate is faster and uses lesser resources than Delete. Statement Syntax:

Truncate Table Table_Name

Example:

Truncate Table Employee

Drop Table: SQL DROP TABLE statement is used to delete a table definition and all its data from a table including index, constraint, triggers etc.

Syntax:

Drop Table Table_Name

Example

Drop Table Employee