How many types of local table in sql define with syntax
| There are 2 types of temporary tables, local and global. Local temporary tables are created using a single pound (#) sign and are visible to a single connection and automatically dropped when that connection ends. Global temporary tables are created using a double pound (##) sign and are visible across multiple connections and users and are automatically dropped when all SQL sessions stop referencing the global temporary table.
CREATE TABLE #MyTempTabl |
|
| e
(
PolicyId INT IDENTITY(1,1) PRIMARY KEY NOT NULL, LastName VARCHAR(50) NOT NULL) | |