# Local Temporary Tables (Continue...)

__*LOCAL TEMPORARY TABLE*__

```
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)
```
------------------------------------------------------------
[no notes]