Re: Scripting Issues

2005-11-11 Thread Dobromir Velev
Hi, Why don't you run the CREATE TABLE query with the IF NOT EXISTS clause then your script could look like this CREATE TABLE IF NOT EXISTS table_name ...; ALTER TABLE table_name; If the table already exists only the ALTER statement will be executed, otherwise the ALTER statement will not do any

Scripting Issues

2005-11-11 Thread Luke
Hey all, I've got a question for you. What would be the best way to set up a set of srcipts to create\Update the databse when my app is installed? The problem is that I obviously can't just drop the database cause if the database is already installed then the client would lose all his data. I n