Share via

Creating a Database

  • Article

After you have designed your database and determined what fields you might need, you are ready to create your database.

In This Section

  • Database Creation Process
    Learn how to create a database, a database container, gather tables together into one collection, and use data dictionary features.
  • Working with a Database
    Explains how a database provides a working environment that can be used to store a collection of tables, establish relationships between the tables, and set properties and data validation rules that control how the related tables work together.
  • Adding Tables to a Database
    Describes how adding a table creates links between the table file and the database container. When you create a new database, it is empty, containing no associated tables or other objects.
  • Updating Table and Database Links
    Moving a database file or a table associated with a database will change the relative paths and might break links that Visual FoxPro uses to associate database and table files. You will need to reestablish links and update the relative path information to reflect the new file location.
  • Removing a Table from a Database
    Learn how to remove a table from a database, which also removes the table and associated data dictionary information from the database file, but does not delete the table.
  • Creating Persistent Relationships
    Explains how persistent relationships are relationships between database tables that are stored in the database file.
  • Building Referential Integrity
    Describes how to open and use the Referential Integrity Builder and gives background on how to create a set of rules to maintain the defined relationships between tables when adding or deleting records.
  • Creating Stored Procedures
    Explains how to create, modify, or remove a stored procedure.
  • Viewing and Setting Database Properties
    Explains how to view and set Version and Comment properties within a Microsoft Visual FoxPro database.
  • Designing Databases
    Explains how to take advantage of relational database technology in Visual FoxPro with well-planned databases.
  • Viewing and Modifying Database Architecture
    Provides descriptions of how to view a database file, a schema, and database objects, as well as explains how to validate a database and extend a .dbc file.
  • Managing a Database
    Gives instructions on how to add or remove a database from a project, or delete a database altogether, as well as explains how to handle database errors and reference multiple databases.