Reserving Space for Database Objects
The process of setting up databases varies a great deal from vendor to vendor. In some cases, a single RDBMS server supports multiple databases, each dedicated to a particular kind of data or application. In others, a server and a database are pretty much the same thing, but space within the single database is clearly divided among different uses by permissions, ownership, and space allocations. You create a database with a vendor utility or GUI tool or a CREATE DATABASE command.
The 1992 SQL ANSI standard (often called SQL-92) does not include a CREATE DATABASE command. Instead, it provides a CREATE SCHEMA command for defining the part of a database that a specific user owns. Typically, a database consists of more than one schema.
SQL VARIANTSMost commercial versions of SQL, however, have a CREATE DATABASE command. The full syntax for the Adaptive Server Anywhere CREATE DATABASE command, for example, looks like this: Adaptive Server AnywhereCREATE 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 ]
]
|