| **Navigation:**  SQL Drivers > [[sqlite driver.htm|SQLite Accelerator]] >SQLite Properties | [[sqlite driver strings.htm|{{btn_prev_n.gif|Previous page}}]][[sqlite driver.htm|{{btn_home_n.gif|Return to chapter overview}}]][[sqlite multi-user.htm|{{btn_next_n.gif|Next page}}]] |
|  ||

**PROP:CreateDB **\\ ** **

PROP:CreateDB is a command property.  This command property tells the SQL Accelerator to create the SQLite Database file that is specified in the OWNER attribute of the file.

If the database file already exists, this command does nothing.  The existing database file will not be destroyed.

You can also create a database by issuing a CREATE statement for any table in that database.  If the database does not exist, it will be created and the table will also be created in the database.

You would use this property if you are using SQL statements to create the database rather than the Clarion CREATE statement.

Example:

sqlTable FILE,DRIVER('SQLite'),OWNER('MyDatabase.sqlite')

RECORD

END

END\\

CODE

sqlTable{PROP:CreateDB}  ! Will create the file MyDatabase.sqlite

IF ERRORCODE() ! test to see if the create worked\\