The SQLite command line utility has a .schema TABLENAME command that shows you the create statements.