Click here for aggregate storage version
Create or re-create a regular or currency database. Optionally create the database as a copy of another database on the same system. DBS-NAME must consist of 8 or fewer characters. Avoid spaces and special characters when naming applications and databases.
Permission required: Application designer. To copy a database, designer permission on the source database is additionally required.
create or replace database Sample.Basic comment 'This is a test.';
Creates a database called Basic within the Sample application. If a database named Basic within the Sample application already exists, it is overwritten.
create database Sample.New as Sample.Basic;
Creates a database called New within the Sample application that is a copy of the database Basic within the Sample application.
create currency database Sample.Interntl;
Creates a currency database called Interntl within the Sample application.
Use create database to create a database in the following ways:
Key Phrase | Explanation |
---|---|
create database | Create a new database. Database names are case sensitive. |
create or replace database | Create a database, or replace an existing database of the same name. Database names are case sensitive. |
create database as | Create a database as a copy of another database. Database names are case sensitive. |
create currency database | Create or replace a database for currency conversion. Linking a currency database to a main database enables you to convert currency values in a database from one currency into another currency. |
comment | Create a database description (optional). The description can contain up to 80 characters. |
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |