SQL - # used while creating a temp table

Question

I'm just wondering why # was used while creating this temporary table.

create table **#tmp** ( 
  Things to wonder about
)

The query works perfectly fine with/without it.

Which dbms are you using? (That behavior is product specific.) — jarlh, Jun 18 '18 at 12:37
https://stackoverflow.com/questions/21011276/difference-between-temptable-and-temptable — , Jun 18 '18 at 12:38
In SQL server a single # needs to prefix the name of local temporary tables. If you omit it, you're actually creating a non temporary table. — vc 74, Jun 18 '18 at 12:40

score 0 · Accepted Answer · answered Jun 18 '18 at 13:10

0

vc74 answered the question

In SQL server a single # needs to prefix the name of local temporary tables. If you omit it, you're actually creating a non temporary table. – vc 74

answered Jun 18 '18 at 13:10

SuperMan

1 Answers1