Select from following answers:- It starts with single hash value "#" as the prefix of the table name.
- A Local Temporary Table is only for the connection in which it was created.
- A Local Temporary Table is automatically dropped when the existing connection is closed, or the user can explicitly drop it with the following command "drop table #local_table.".
- If the Temporary Table is created in a Stored Procedure then it is automatically dropped on the completion of the Stored Procedure execution.
- All Above

Above all statements are correct about Local Temporary Tables i.e. it starts with Single # sign and exists only in current session.
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator