Working with Items in Databases

After you create a database, you can perform various tasks, for example:

• Configure how to display items in the database.

• Add tables or create new tables and views to the database.

• Find tables in the database.

• Update links between databases and the tables they contain when database or table files are moved.

• Define relationships between database tables.

• Create rules governing adding, updating, and deleting records in database tables.

In This Section

• How to: Display Items in Databases
  Describes how to choose items and how they display in the Database Designer.

• How to: Associate Tables with a Database
  Describes how to create or add tables to a database.

• How to: Find Tables or Views in Databases
  Describes how to quickly locate tables and views in the Database Designer.

• How to: Arrange Tables and Views in Databases
  Describes how to arrange the layout of tables in the Database Designer.

• How to: Use Tables from Other Databases
  Describes how to include data from tables not associated with the current database.

• How to: Update Table and Database Links
  Describes how to update links between tables and the database when moving database files or database tables.

• How to: Remove a Table from a Database
  Describes how to remove or delete tables from a database.

• How to: Create Persistent Relationships Between Tables
  Describes how to create persistent relationships between database tables so you can access records easier.

• How to: Manage Persistent Relationships Between Tables
  Describes how to edit or delete persistent relationships between tables.

• How to: Build Referential Integrity Between Tables
  Describes how to create a set of rules to preserve relationships between database tables when adding, updating, or deleting records.

Related Sections

• Databases in Visual FoxPro
  Introduces databases in Visual FoxPro and provides information about their aspects.

• Creating Databases
  Describes how to create databases and work with tables in databases.

• Designing Databases
  Describes design considerations for creating well-planned databases.

• Working with Tables (Visual FoxPro)
  Describes using tables to store data and managing them.