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 properties of the relational tables?

926

How optimize sql query with multiple joins in sql server?

951

How can you check the version of sql server?

1156

Explain full-text query in sql server?

1053

do you know how to configure db2 side of the application? : Sql server database administration

1094

What is the use of sql profiler in sql server 2012?

943

What stored by the model?

1139

Can we return Data from 4(more than 1) tables in stored procedure?

1105

What are sql dirty pages?

1081

Can we check locks in database? If so, how can we do this lock check?

984

What is mean by candidate key?

1060

Give me any three differences between Truncate and Delete.

1154

Can a table be moved to different filegroup?

1025

How to check table values in sql server?

1007

What do you understand by physical_only option in dbcc checkdb?

1020