Dropping Temporary Table in SQL Server
Hello everyone,
In this article, I will try to give information about how to drop Temp tables in SQL Server.
You can easily do this using the code below.
CREATE TABLE #TempTable
(
ID INT,
NameSurname VARCHAR(50)
);
IF OBJECT_ID('tempdb..#TempTable') IS NOT NULL
DROP TABLE #TempTable;When you run the above code, you will see a result similar to the one below.
As you can see, the temp table has been removed.
Good luck to everyone in business and life.
174 Views
