I recently saw a statement like:
CREATE TABLE #tbl_AR_Data
I wanted to know what is the purpose of the symbol
# (NUMBER SIGN, hash, pound sign) in this statement?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
'#' denotes a temporary table.
This tells SQL Server that this table is a local temporary table. This table is only visible to this session of SQL Server. When I close this session, the table will be automatically dropped.
You can treat this table just like any other table with a few exceptions. The only real major one is that you can't have foreign key constraints on a temporary table.
Temporary tables are available in MySQL version 3.23 onwards. If you use an older version of MySQL than 3.23, you can't use temporary tables, but you can use heap tables.
Read about usage and syntax here.