|
The Delete statement is used to remove records from a table.
Table Name ‘Users’
|
U_Id
|
FirstName
|
LastName
|
City
|
|
1
|
Ajay
|
senha
|
New York
|
|
2
|
Vinda
|
kapoor
|
Los Angeles
|
|
3
|
Qasim
|
bilal
|
New York
|
DELETE FROM Users
WHERE FirstName='Vinda'
Delete all rows from a table.
DELETE FROM Users
Or
DELETE * FROM Users |