Table Field Naming Conventions

  • Article

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

Reference

Constant Naming Conventions
Object Naming Conventions
Variable Naming Conventions
Window Naming Conventions

Concepts

Creating Visual FoxPro Names

Other Resources

Naming Conventions