How do I list all the columns in a table?

Question

For the various popular database systems, how do you list all the columns in a table?

Accepted Answer

For MySQL, use:

```
DESCRIBE name_of_table;
```

This also works for Oracle as long as you are using SQL*Plus, or Oracle's SQL Developer.

Solution