The create database syntax is:
create database database_name
[on {default | database_device} [= size]
[, database_device [= size]...]
[log on database_device [ = size ]
[, database_device [= size]]...]
[with {override | default_location = "pathname"}]
[for {load | proxy_update}]
A database name must follow the rules for identifiers. You can create only one database at a time.
In its simplest form, create database creates a database on the default database devices listed in master..sysdevices:
create database newpubs
You can control different characteristics of the new database by using the create database clauses:
The on clause specifies the names of one or more database devices and the space allocation, in megabytes, for each database device. See “Assigning space and devices to databases” for more information.
The log on clause places the transaction log (the syslogs table) on a separate database device with the specified or default size. See “Placing the transaction log on a separate device” for more information.
for load causes Adaptive Server to skip the page-clearing step during database creation. Use this clause if you intend to load a dump into the new database as the next step. See “Using the for load option for database recovery” for more information.
with override allows Adaptive Servers on machines with limited space to maintain their logs on device fragments that are separate from their data. Use this option only when you are putting log and data on the same logical device. See “Using the with override option with create database” for more information.
size is in the following unit specifiers: ‘k’ or ‘K’ (kilobytes), ‘m’ or ‘M’ (megabytes), and ‘g’ or ‘G’ (gigabytes), ‘t’ or ‘T’ (terabytes). If you do not specify the unit size, create database assumes 'M', megabytes.
