Temporary table name is prefixed with '#', does it apply in naming its index or it doesn't matter? Is there any rule or convention for naming the index on a temporary table?
Thanks in advance.
There are no special rules for indices on temporary tables. The standard rules for identifiers in SQL Server apply here.