How to delete / drop SQL table? The following code will guide you to drop the temporary SQL table. Basically, you just need to type in ‘DROP TABLE tableName‘.
IF OBJECT_ID(N’tempdb..#temptable’, N’U') IS NOT NULL
DROP TABLE #temptable;
GO
Jayce Ooi is the founder of Jayce Ooi's Paradise. He is a full time tech blogger, SEO consultant and investor. He also maintains spBlogger.com make money online blog.
... Have you noticed
