Answer / guest

Checking whether a table exists in a Microsoft SQL Server
database is easy. You can use this query:

SELECT 'x'
FROM sysobjects
WHERE type = 'U' and NAME = 'mytable'
But this query will not work while searching for global
temporary tables. Global temporary tables are stored in tempdb.
Use this syntax for the search:

DECLARE @temp_table VARCHAR(100)
SET @temp_table = '##my_temp_table'
IF NOT EXISTS (SELECT 'x'
FROM tempdb..sysobjects
WHERE type = 'U' and NAME = @temp_table)
PRINT 'temp table ' + @temp_table + ' does not exist'

ELSE
PRINT 'temp table ' + @temp_table + ' exists.'
Note: You cannot search for local temporary tables (# prefix
tables) in this way. This is because SQL Server appends a
unique number to the name you supply. For example, if you
specified "#temp," the name in sysobjects would be something
like "#temp____1234."

Answer / ish

use tempdb

sp_tables '##%'

How to delete an attribute from the emp table

4 Answers  

---

What are the differences between union, intersect, and minus operators?

0 Answers  

---

What is difference between table aliases and column aliases? Do they affect performance?

0 Answers  

---

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

0 Answers  

---

How to get nth highest salary from employee table.

0 Answers  

---

What is a view in sql?

0 Answers  

---

What is the difference between varchar and nvarchar datatypes?

0 Answers  

---

How to configure and test odbc dsn settings?

0 Answers  

---

Is SET a SQL Keyword?

4 Answers   BitWise,

---

What are SSL and TSL protocols?

0 Answers   Wipro,

---

sql database suspect We have a sql database that is showing as suspect. How can we recover?

0 Answers  

---

Indexes are updated automatically is the full-text index also updated automatically?

0 Answers  

---