Creates and opens a database.

CREATE DATABASE [DatabaseName | ?]

Parameters

[ DatabaseName| ?]

Specifies the name of the database to create or opens the Create dialog box so you can specify a name for the database and the location where you want to save the database. Omitting arguments for these parameters also opens the Create dialog box.

Database files are saved with a .dbc file name extension.

Note
If the SET SAFETY command is set to ON, and the database name that you specify has the same path and name as an existing database, Visual FoxPro prompts you to specify a different path or name for the database.

Remarks

Example

This example creates a database named people. A table named friends is created and is automatically added to the database. DISPLAY TABLES is used to display the tables in the database, and DISPLAY DATABASES is used to display information about the tables in the database.

	Copy Code
CREATE DATABASE people CREATE TABLE friends (FirstName C(20), LastName C(20)) CLEAR DISPLAY TABLES && Displays tables in the database DISPLAY DATABASES && Displays table information

See Also