Chapter 9 SQL Statements
427
CREATE DATABASE statement
Use this statement to create a database. The database is stored as an
operating-system file.
CREATE DATABASE
db-file-name
… [
… [ [ TRANSACTION ] LOG OFF
| [ TRANSACTION ] LOG ON [
log-file-name-string
]
[ MIRROR
mirror-file-name-string
]
]
… [ CASE { RESPECT | IGNORE } ]
… [ PAGE SIZE
page-size
]
… [ COLLATION
collation-label
]
… [ ENCRYPTED { ON | OFF } ]
… [ BLANK PADDING { ON | OFF } ]
… [ ASE [ COMPATIBLE ] ]
… [ JAVA { ON | OFF } ]
… [ JCONNECT { ON | OFF } ]
]
page-size
:
1024 | 2048 | 4096 | 8192 | 16384 | 32768
collation-label:
string
The permissions required to execute this statement are set on the server
command line, using the
-gu command-line option. The default setting is to
require DBA authority.
The account under which the server is running must have write permissions
on the directories where files are created.
Not supported on Windows CE.
An operating system file is created.
"ALTER DATABASE statement" on page 383
"DROP DATABASE statement" on page 507
"The Initialization utility" on page 98
Creates a database file with the supplied name and attributes.
File name The file names ( db-file-name-string, log-file-name-string,
mirror-file-name-string) are strings containing operating system file names.
As literal strings, they must be enclosed in single quotes.
Function
Syntax
Permissions
Side effects
See also
Description
Parameters
To Next Page
Loading...