# Local Temporary Tables - Demo

+ Statement 1: Create a non-temporary table called `test.temp1`
+ Statement 2: Create a local temporary table called `test.temp1` 
+ Statement 3: Describe `test.temp1` 
+ Statement 4: Drop table `test.temp1`
+ Statement 5: Describe `test.temp1`

```
tidb> CREATE TABLE test.temp1 (id int);
Query OK, 0 rows affected (0.51 sec)

tidb> CREATE ~!@TEMPORARY@!~ TABLE test.temp1 (name CHAR(10));
Query OK, 0 rows affected (0.00 sec)

tidb> DESC test.temp1;
+-------+----------+------+------+---------+-------+
| Field | Type     | Null | Key  | Default | Extra |
+-------+----------+------+------+---------+-------+
| name  | char(10) | YES  |      | NULL    |       |
+-------+----------+------+------+---------+-------+
1 row in set (0.00 sec)

tidb> DROP TABLE test.temp1;
Query OK, 0 rows affected (0.00 sec)

tidb> DESC test.temp1;
+-------+---------+------+------+---------+-------+
| Field | Type    | Null | Key  | Default | Extra |
+-------+---------+------+------+---------+-------+
| id    | int(11) | YES  |      | NULL    |       |
+-------+---------+------+------+---------+-------+
1 row in set (0.00 sec)
```
------------------------------------------------------------
Statement 2: This local temporary table shares the same name as the table created in the statement 1.

Statement 3: The table returned is the local temporary table.

Statement 5: The table dropped in statement 4 is the local temporary table.