Question: I try to rename the table 'folks' to 'users'.
How does it work?

Answer: 
In this case you can use `ALTER TABLE` with `RENAME TO`.

**Syntax:**

```
ALTER TABLE <Tablename>
RENAME TO <new Tablename>;

```

**Example:**

```
ALTER TABLE folks
RENAME TO users;

```
If you want to rename the column and also change its type

```
ALTER TABLE [TableName] CHANGE [Column] [ColumnName] [New type];

```

For example:

```
ALTER TABLE folks CHANGE FolkAddress Address VARCHAR(1024);

```