Database Menu

The Database menu contains commands for creating and editing tables in a database.

Database Menu Commands

New Table

Displays the New Table dialog box where you can create a new table using the Table Wizard or Table Designer.

Add Table

Displays the Open dialog box so you can add an existing table to a database. You can select any table that is not currently part of another database. Since tables can only belong to one database at a time, you need to remove a table from a database before you can use it in a new database.

New Remote View

Displays the New Remote View dialog box where you can create a new remote view using the Remote View Wizard or the View Designer.

New Local View

Displays the New Local View dialog box where you can create a new view of a local table using the Local View Wizard or View Designer.

Modify

Opens the selected table in the Table Designer, or the selected view in the View Designer. Use the Table Designer to create and modify tables, fields, indexes, default field values, validation rules, triggers, and comments.

Browse

Displays the selected table in the Browse window for viewing and editing.

Remove

Prompts you to remove the selected table from the database or to delete it from the disk. Removing a table removes it from the database, but leaves the table's .dbf file on the disk. Deleting a table removes the table from the database and permanently removes the table's .dbf file from the disk.

Find Object

Displays the Find Table or View dialog box so you can locate objects in the database schema.

Rebuild Table Indexes

Generates keys and rebuilds indexes for the selected table. The number of records indexed appears in the status bar.

Remove Deleted Records

Displays a prompt asking whether you want to permanently remove all records marked for deletion from the active table.

Edit Relationship

Displays the Edit Relationship dialog box where you can alter the persistent relationship between tables. Enable this command by selecting a relationship line in the Database Designer.

Edit Referential Integrity

Displays the Referential Integrity Builder, in which you set up rules to control how records are inserted, updated, or deleted in related tables.

Edit Stored Procedures

Displays all Visual FoxPro stored procedures for the current database in an editing window.

Connections

Displays the Connections dialog box, in which you can choose to modify an existing connection to a remote data source or choose to create a new one.

Arrange

Displays the Arrange dialog box, in which you can choose the option to order, align, or resize the objects displayed in the Database Designer.

Refresh

Updates the display in the Database Designer with the current disk image of the database.

Clean Up Database

Runs the PACK command to decrease the size of the database by removing rows that have been marked for deletion. You can use the VALIDATE DATABASE command to clean up links between databases and tables.

Properties

Displays the Database Properties dialog box, in which you can choose which objects appear in the schema display or add a comment to the database.