Difference between Drop and Delete

Difference between Drop and Delete 

Drop - deletes the data as well as structure. The difference between DROP and DELETE table is that, after executing DELETE statement the contents of table are removed but the structure remains same, but in case of DROP statement both the contents and structure are removed.

No comments:

Post a Comment

Subscribe to: Posts (Atom)

How to register multiple implementations of the same interface in Asp.Net Core?

 Problem: I have services that are derived from the same interface. public interface IService { } public class ServiceA : IService { ...

  • What is a synonym in SQL Server
    In SQL Server, a synonym is an alias or alternative name for a database object such as a table,  view ,  stored procedure ,  user-defined fu...
  • What is Microservices?
    Microservice architecture, or simply microservices , is a distinctive method of developing software systems that tries to focus on buildi...