To see the structure of a database, the describe command can be used. The syntax is simple:
describe tablename;