Database Tutorial in Amharic Lesson 11 - Delete Query

In this Tutorial I will cover Delete and Truncate topics.
To Remove data from a table we can use Delete OR Truncate.

Delete:
1. Can be recovered from the transaction log
2. Doesn’t reset Identity column

Truncate
1. CANNOT be recovered once truncated
2. Resets Identity column

Delete Syntax:
DELETE FROM [TableName] WHERE [Condition]

Query for delete
DELETE FROM Department WHERE ID=9

Truncate Syntax:
Truncate Table [TableName]

Truncate Query:
TRUNCATE TABLE Department

[ethiobot]

amazing
let me comment some thing from what i learn

use habesha it
go
create table name subscribe(like int not null,
subscribe varchar not null, )
share
go