Creates a new database.
create database database_name
[on {default | database_device} [= size]
[, database_device [= size]]...]
[log on database_device [= size]
[, database_device [= size]]...]
[with override]
[with default_location = “pathname”]
[for proxy_update]
[for load]
This command creates a new database within Adapter Server. The syntax with default_location = pathname and for proxy_update allows automatic creation of proxy tables representing tables and views found in a remote location.
If the clause with default_location = pathname is used, the pathname is stored in master.dbo.sysdatabases.default_loc, and serves the same purpose as the default location added using sp_defaultloc.
If the clause for proxy_update is used, the with default_location = pathname clause must also be used. This clause indicates that the database is to be a proxy database, and all tables created in it will become proxy tables, referencing objects contained at the default location.
When a database is created as a proxy database, and no device or size specification is included in the syntax, the default size is calculated based on the number of proxy tables that it is expected to contain. The formula for calculating the number of 2K, 4K, 8K, and 16K pages for the database is as follows:
1MB for every 100 proxy tables plus size of model database plus 1MB
The new database is placed on the default device, if no device name is specified.
After the database is created, but before the command is complete, the presence of the for proxy_update clause instructs Component Integration Services to create a proxy table in the new database for each remote table or view. When the create database command is finished, the newly created database is populated with proxy tables representing all user tables and views found at the remote location.
alter database in the Reference Manual
