sql - Global Temporary table delete operation -


Whether or not there is a global floating table in SQL Server, if yes, to delete that global floating table?

I am trying to execute it:

  If OBJECIDID ('## Table', 'U') is not a Null Drop Table # Table < / Code> 

... but it is not working.

check the existence of a temporary table and delete it

  IF OBJECT_ID ('tempdb. # Table', 'U') is not a null drop table ## Table  

Comments

Popular posts from this blog

MySql variables and php -

url rewriting - How to implement the returnurl like SO in PHP? -

Which Python client library should I use for CouchdB? -