Working with Tables

  • Article

Building your database includes creating tables. When you designed your database, you specified the table fields and relationships required for your application. Now, as you create those tables, you make more detailed choices about the data types, captions, and potential default values for each field, the triggers for each table, and the table indexes you build to establish relationships between tables.

In This Section

  • Table Creation
    Provides an overview on how to create tables and includes descriptions of interactive and programmatic table creation.
  • Field Creation
    Describes the process of creating table fields and introduces explanations of how to name fields and restrict access to fields.
  • Enforcing Business Rules
    Details how to enforce business rules by creating field-level and record-level rules, called validation rules.
  • Trigger Usage
    Gives a description of triggers and how they are used and points to topics on creating, modifying, removing, and deleting triggers.
  • Modifying the Table Structure
    Describes how to add, change, or delete field names, widths, data types, change default values, or rules, as well as add comments or captions.
  • Working with Multiple Tables
    Explains how to open a data session window, and how to open and close a table in a work area.
  • Data Access Management Using CursorAdapters
    Describes support for working with different data source types as native Visual FoxPro cursors using CursorAdapter objects.
  • Working with Data
    Find out how to create effective applications with indexes, tables, and databases based on your data requirements.
  • Developing Databases
    Use databases in Visual FoxPro to establish relationships between tables, enforce referential integrity, and manage local and remote data.
  • Working with Records
    Store data in the table by adding new records. Through the interface or by using commands you can change and delete existing records.
  • Importing and Exporting Data
    Information is copied between Visual FoxPro and other applications by importing to and exporting from Visual FoxPro.
  • Choosing Data Types
    Lists the decision made when choosing a field's data type and provides explanations of how to choose a data type for a field, how to control entering null values per field, how to permit null values in all table fields, and how to add a comment to a field in a database table