Re: [sqlite] What is the preferred way to create SQLite databases?

2007-11-29 Thread Chris Peachment
At the command line prompt: sqlite3 name_of_database_to_be_created SQLite version 3.5.2 Enter ".help" for instructions sqlite>.read database_definition_text_file_name sqlite>.quit On Thu, 2007-11-29 at 15:43 -0600, Mark Brown wrote: > Hi- > > What is the prefe

[sqlite] What is the preferred way to create SQLite databases?

2007-11-29 Thread Mark Brown
Hi- What is the preferred way to create SQLite databases? Ideally, I would like to have the entire schema in a file, and then generate the DB from that, as we make changes to the schema often. We're currently using something called SQLite Database Browser, but I am becoming concerned