Drop in SQL

Question

hi What is the difference Truncate and Drop command in SQL Server?

Satyapriya Nayak · Answer

Normal 0 Hi John Drop means removing the existing object from the database (Both data and structure of the table gets removed). Truncate will delete only the data while Keeping the structure of the table as it is. Thanks

Vulpes · Answer

Check out this thread where a similar question was asked: http://www.c-sharpcorner.com/Forums/Thread/134569/what-is-the-difference-between-drop-delete-and-truncate.aspx