Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Sql Server query

Home
Forums

Sql Server query

Ashok

Ashok

8yAsked Jan 23, 2018, 1:23 AM801

Hi All,

can we drop or delete the temporary table by manually ?

can we drop or delete the temporary variable by manually ?

in sql server

please help me

thanks all

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Nilesh Yadav8y ago
Accepted answer
Try This, I Think It really gonna Work.
IF (EXISTS (SELECT * FROM
     Information_Schema.Tables
      Where table_name = Your_Table_Name))
Begin
        Drop Table Your_Table_Name
End
0
Nanddeep Nachan8y ago
Below simple Query will help drop temp table
DROP [TEMPORARY] TABLE [IF EXISTS] tbl_name [, tbl_name] ... [RESTRICT | CASCADE]
+1