Delete operation in SQL Server 2008
In this article I am going to explain about how to implement Delete operation in SQL Server
Delete operation:
In this article I am going to explain about how to implement Delete operation in SQL Server. It is possible to Removed of all rows in a table and Removed of specific row from the table.
The delete command delete row from the table.
- Removed of all rows from the table.
- Removed of specific row.
1. Removed of all rows from the table.
It is possible to delete all rows in a table without deleting the table. This means that the table structure, attributes, and indexes will be intact:
Example:
We create one table named aaa in the SQL database which looks as in the following image.
To delete all rows from aaa table without deleting the table, type following code.
4 row deleted from table named aaa .
2 . Removed of specific row.
It is possible to delete specific one rows in a table without deleting the table.
We create one table named aaa in the SQL database which looks as in the following image.
To delete 1 row deleted from table named aaa.
1 row deleted from table named aaa .