Partager via


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