Monday, 20 September 2021

How to get a list of global temporary tables in the current database?

 SELECT * FROM tempdb.sys.tables

WHERE name LIKE '##%'

No comments:

Post a Comment