Access Table Definition. How to build a table by extracting some fields from a main database. A TableDef object represents the stored definition of a base table or a linked table Microsoft Access workspaces only.
For example you might have one table containing general non-confidential information and another containing the employees personal information. A table has records rows and fields columns. Typically they are explained by providing information about one table and how it relates to another table.
Query a main database mainframe and create a local table.
After you create several tables you might want to print out their definitions to provide a permanent paper record. Access provides the data definition language DDL query which is used to programmatically create or modify tables. Learn more about creating and modifying tables in Microsoft Access. If the foreign tables primary key consists of more than one field you must use a multiple-field constraint definition listing all of the referencing fields the name of the foreign table and the names of the referenced fields in the foreign table in the same order that the referencing fields are listed.
