Databases in Visual FoxPro

Databases provide an architecture and working environment for associating, organizing, and working with tables and views. You can use databases independently or include them in an application project. When you create a database, Visual FoxPro creates and opens a database (.dbc) file exclusively. The database file, which is a table, stores all the information about the database including the names of files and items associated with it. The database file does not physically contain top-level items such as tables or fields. Instead, the database file stores file path pointers to tables associated with the database.

Databases provide additional benefits such as the following:

  • Associate tables with a database.

  • Create persistent relationships between tables.

  • Make it possible for you to create field and record-level validation rules without writing code.

  • Create rules to preserve the relationships between database tables when adding, updating, or deleting records.

  • Create stored procedures.

  • Create views from local and remote tables.

  • Access connections to remote data sources.

To view the structure of a sample database, open the NorthWind.dbc file located in the Visual FoxPro ...\Samples\Northwind directory. For more information, see How to: Open Databases.

Expand imageData Dictionary Features of Databases

Expand imageTables in Databases

Expand imageLinks Between Tables and the Database

Expand imagePersistent Relationships Between Database Tables

Expand imageReferential Integrity Between Database Tables

Expand imageStored Procedures in Databases

Expand imageMultiple Databases for Multiple User Environments

Expand imageSee Also

© , 1996-2020 • Updated: 11/10/20
Comment or report problem with topic