Three ways SQL server removes table information

1. Use Delete to implement SQL Server Delete table information

(1) Delete all information from the table

Use student

GO

Delete student--Removes all records from the table without a Where condition

Go

(2) Delete eligible records from the table

Use student

GO

Delete student where id= ' 001 '--delete eligible records from the table

GO

2. Use truncate to delete information from tables

Use student

GO

TRUNCATE Table Student--Delete all the information in the table

GO

3. Delete records from a table using drop

Use student

GO

DROP TABLE Student--sql Server Remove all information from the table

GO

Three ways SQL server removes table information