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.
  • 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
  • Creating Default Field Values
    Explains how to assign a default value to a database table field and how to provide an input mask.
  • Controlling Display of a Field
    Offers an explanation of how to control the appearance of fields and their values on forms, browse windows, and reports using additional properties for 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 Data
    Find out how to create effective applications with indexes, tables, and databases based on your data requirements.
  • Designing Databases
    Take advantage of relational database technology in Microsoft® Visual FoxPro® with well-planned databases.
  • Creating Databases
    Use databases in Microsoft® 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 Microsoft® Visual FoxPro® and other applications by importing to and exporting from Visual FoxPro.