use tempdb sp_tables '##%'

How to Check Whether a Global Temporary Exists in a SQL
Database or not?

Question Posted / ish

Answer Posted / ish

use tempdb

sp_tables '##%'

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what are the types of indexes? : Sql server database administration

1122

How to drop an existing table?

1005

What is ms sql server reporting services?

1055

Explain logical operators in sql server?

1107

What is Service Broker in sql server 2012?

1020

Mention what are the core components of ssrs?

323

How to drop an existing stored procedure in ms sql server?

1032

What is the order in which the sql query is executed?

942

how would you store your query in an SSRS report or a Database server?

162

Which are the two editions in which SQL Azure database available?

119

What is the purpose of indexing?

1044

What is coalesce and check constraint in sql server?

1122

What are the different types of sql server replication? : sql server replication

1272

Explain different types of locks in sql server.

1079

Explain datetime2 data type in sal server 2008?

911