# 复制现有表格结构 (继续...)

__**复制表结构**__

```
create table test.dropme2 ~!@like@!~ test.dropme;
Query OK, 0 rows affected (0.52 sec)

tidb> desc test.dropme;
+---------+---------------+------+------+---------+-------+
| Field   | Type          | Null | Key  | Default | Extra |
+---------+---------------+------+------+---------+-------+
| id      | bigint(20)    | NO   | PRI  | NULL    |       |
| uuid    | bigint(20)    | NO   |      | NULL    |       |
| isvalid | enum('T','F') | NO   |      | F       |       |
+---------+---------------+------+------+---------+-------+
3 rows in set (0.00 sec)

tidb> desc test.dropme2;
+---------+---------------+------+------+---------+-------+
| Field   | Type          | Null | Key  | Default | Extra |
+---------+---------------+------+------+---------+-------+
| id      | bigint(20)    | NO   | PRI  | NULL    |       |
| uuid    | bigint(20)    | NO   |      | NULL    |       |
| isvalid | enum('T','F') | NO   |      | F       |       |
+---------+---------------+------+------+---------+-------+
3 rows in set (0.00 sec)
```
-----------------------------------------------------------
[no notes]