When a user with the required permission issues create database, Adaptive Server:
Verifies that the database name specified is unique.
Makes sure that the database device names specified are available.
Finds an unused identification number for the new database.
Assigns space to the database on the specified database devices and updates master..sysusages to reflect these assignments.
Inserts a row into sysdatabases.
Makes a copy of the model database in the new database space, thereby creating the new database’s system tables.
Clears all the remaining pages in the database device. If you are creating a database to load a database dump, for load skips page clearing, which is performed after the load completes).
The new database initially contains a set of system tables with entries that describe the system tables themselves. The new database inherits all the changes you have made to the model database, including:
The addition of user names.
The addition of objects.
The database option settings. Originally, the options are set to “off” in model. If you want all of your databases to inherit particular options, change the options in model with sp_dboption. See Chapter 2, “System and Optional Databases,” for more information about model. See Chapter 22, “Setting Database Options,” for more information about changing database options.
