Database-Level Tasks

The database you use is called the current database. To select an existing database as current, you can:

Use the following command line syntax:
```
dbaccess databasename
```
For more information about using DB–Access from the command line, see Invoking DB-Access.

Use any method from within DB–Access that is described in the following list.

Menu Screen	Option or SQL Statement	Action	Chapter
CONNECTION	Connect	Prompts for database server, username, password, and database name. Connects you according to the choices you make.	6
SQL	CONNECT	Connects to a database. If you use a fully-qualified database name, you simultaneously connect to the database server.	3
DATABASE	Select	Chooses a current database from a list of databases available on the current database server.	4
SQL	DATABASE	Chooses a database as current.	3

To create your own database, use one of the following methods.

Menu Screen	Option or SQL Statement	Action	Chapter
DATABASE	Create	Prompts for a database name, dbspace, and log options and then creates the new database.	4
SQL	CREATE DATABASE	Creates the database you name in the statement with the appropriate setup for the keywords you use.	3

To drop a database, use one of the following methods.

Menu Screen	Option or SQL Statement	Action	Chapter
DATABASE	Drop	Lists available databases and drops the database you choose from the list.	4
SQL	DROP DATABASE	Drops the database named in the command.	3

To close a database, use one of the following methods.

Menu Screen	Option or SQL Statement	Action	Chapter
DATABASE	cLose	Closes the current database.	4
SQL	CLOSE DATABASE	Closes the current database.	3
CONNECTION	Disconnect	Closes the current database and disconnect from a database server.	6
SQL	DISCONNECT CURRENT	Closes the current database and disconnect from the current database server.	3

To display information about a database, such as the dbspaces that contain it, choose the Info option on the DATABASE menu.