Interested to Buy Any Domain ? << Click Here >> for more details...
How to Check Whether a Global Temporary Exists in a SQL
Database or not?
- 2 Answers
- 8622 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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."
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is the difference between a primary key and a unique key? : Sql server database administration
What are rows and columns?
List some of the rules that apply to creating and using a ‘view’
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
Explain the truncate command? : SQL Server Architecture
What is table value parameters (tvp)?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
How to enable/disable indexes?
How to grant a permission in ms sql server using "grant execute" statements?
How to see existing views in ms sql server?
What is the maximum size of a dimension? : sql server analysis services, ssas
What gets stored inside msdb database?
Relational calculus is what type of language?
What is the difference between left and right outer join?
