Table Field Naming Conventions

When naming fields in tables, use the following format.

TableAlias.PrefixFieldName

Parameters

• TableAlias
  Specifies the name or alias for a table.

• Prefix
  Indicates the data type for a table field. The following table lists the suggested prefixes for Prefix.

  Prefix	Description
  c	Character
  y	Currency
  d	Date
  t	DateTime
  b	Double
  f	Float
  g	General
  i	Integer
  l	Logical
  m	Memo
  n	Numeric
  q	Varbinary
  v	Varchar, Varchar (Binary)
  w	Blob

• FieldName
  Specifies the name of the field.

Example

The following example illustrates how the letter "c" indicates that the LastName field of the Customer table has Character type:

Customer.cLastName

See Also

Concepts

Creating Visual FoxPro Names

Reference

Constant Naming Conventions

Object Naming Conventions

Variable Naming Conventions

Window Naming Conventions

Other Resources

Naming Conventions