Assertion: temporary table | /r/HasProperty | visible
Facets:
value: to all sessions
type: TRANSITIVE-OBJECT
value: in the current session
type: TEMPORAL
value: to any user
type: TRANSITIVE-OBJECT
Source sentences:
text: Local temporary tables have a single number sign (#) as the first character of their names; they are visible only to the current connection for the user, and they are deleted when the user disconnects from the instance of SQL Server.
text: Global temporary tables have two number signs (##) as the first characters of their names; they are visible to any user after they are created, and they are deleted when all users referencing the table disconnect from the instance of SQL Server.
text: Local temporary tables are visible only in the current session, and global temporary tables are visible to all sessions.
text: Local temporary tables are visible only in the current session, and global temporary tables are visible to all sessions.