Answer: We have to write
tempdb.. followed by Table name in object_id because Temporary Tables are stored in TempDB database.
if(object_id('tempdb..#temp_table_name') is not null)
print 'Table Exists';
else
print 'Not Exists';
Asked In: Many Interviews |
Alert Moderator