Sybase Adaptive Server Anywhere - Page 448

CREATE DATABASE statement
430
♦
Sybase Adaptive Server Enterprise provides a CREATE DATABASE
statement, but with different options.
♦ The following statement creates a database file named
mydb.db in the
C:\ directory.
CREATE DATABASE ’C:\\mydb’
TRANSACTION LOG ON
CASE IGNORE
PAGE SIZE 1024
COLLATION ’437’
ENCRYPTED OFF
BLANK PADDING OFF
JAVA ON
JCONNECT OFF
♦ The following statement creates a database with no Sybase runtime Java
classes. All database operations will execute normally, except for those
involving Java classes or objects.
CREATE DATABASE ’C:\\nojava’
JAVA OFF
Example