Posts Tagged ‘delete’

Difference between delete and truncate

Delete: Whenever we are using delete from tablename, then automatically deleted data internally stored in buffer. We can get it back by using rollback command.

How to delete/drop all the tables from SQL Server

If we want to delete or drop all the tables from SQL Server Database. 1) This is a hidden Stored procedure in sql server, this will be executed for each table in the database you connected. This cant be roll back. EXEC sp_MSforeachtable @command_delete = “DROP TABLE ?” 2)If u want to delete it from […]

Powered by k2schools