albertyw/albertyw.com

Showing Schemas in Different Databases

showing-database-schemas

1503733338

### Cassandra

```sql
describe keyspace <keyspace>;
```

### PostgreSQL

```sql
\dn
```

### MySQL

```sql
SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, COLUMN_TYPE, COLUMN_COMMENT, ORDINAL_POSITION
FROM information_schema.columns
WHERE table_schema = '<DATABASE NAME>'
ORDER BY TABLE_NAME, ORDINAL_POSITION;
```