The CREATE DATABASE statement can be used to create databases in Interactive SQL on your computer. However, you cannot copy them directly to a Windows Mobile device from this application. You must manually copy databases to your Windows Mobile device.
To create a database using the CREATE DATABASE statement
Choose Start » Programs » SQL Anywhere 11 » Interactive SQL.
If the Connect window does not appear automatically, choose SQL » Connect.
On the Identification tab, click ODBC Data Source Name and type SQL Anywhere 11 Demo in the adjacent field.
Type the following statement in the SQL Statements pane of Interactive SQL:
CREATE DATABASE 'c:\\temp\\database-name.db' TRANSACTION LOG ON CHECKSUM ON;
You can also configure database properties such as encryption and page size using the CREATE DATABASE statement. See CREATE DATABASE statement.
From the SQL menu, choose Execute.
A database and transaction log are created in the c:\temp directory of your computer.
For information about copying the database to your Windows Mobile device, see Copying a database to your Windows Mobile device.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|