The Initialization utility
98
The Initialization utility
With the Initialization utility, you can initialize (create) a database. A
number of database attributes are specified at initialization and cannot be
changed later except by unloading, reinitializing, and rebuilding the entire
database:
♦ Case sensitivity or insensitivity
♦ Storage as an encrypted file
♦ Treatment of trailing blanks in comparisons
♦ Page size
♦ Collation sequence
In addition, the choice of whether to use a transaction log and a transaction
log mirror is made at initialization. This choice can be changed later using
the transaction log utility.
You can access the Initialization utility in the following ways:
♦ From Sybase Central, for interactive use under Windows 95/98,NT, or
Java versions on non-win32 platforms.
♦ From the system command line, using the
dbinit
command-line utility.
This is useful for incorporating into batch or command files.
$ For more information about creating a database, see the "CREATE
DATABASE statement" on page 427.
Creating a database in Sybase Central
v To create a database:
1 Open the Utilities folder in the left panel.
2 Double-click Create Database in the right panel. The Database Creation
wizard appears.
3 Follow the instructions in the wizard.
Tip
You can also access this wizard by clicking Tools➤Adaptive Server
Anywhere➤Create Database.