The Database menu contains commands for creating and editing tables in a database.
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.