Sql Server query

Question

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

Nilesh Yadav · 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

Nanddeep Nachan · Answer

Below simple Query will help drop temp table DROP [ TEMPORARY ] TABLE [IF EXISTS] tbl_name [ tbl_name] ... [ RESTRICT | CASCADE ]