.Table.Fields.Add (gb.db)

Sub Add ( Name As String, Type As Integer [ , Length As Integer, Default As Variant, Collation As String ] )

Add a field into a table being created.

  • Name : The name of the field.

  • Type : The field datatype.

  • Length : The maximum length of the field. It is used only for String fields.

  • Default : The optional default value. If not specified, the default value is NULL.

  • Collation : The optional collation for string fields.

The possible field datatypes are: