Sorry, I had two errors; first was misspelling the file extension .sqlite (so .schema returned nothing; so I thought that your create statement was a command to be issued ...) and then assuming that familiar mysql commands like show tables; must be standard.