SQLzoo.net

CREATE a new table

Access
The following are examples of field types:
INTEGERA whole number
VARCHAR(10)Up to 10 characters.
CHAR(10)Fixed number of characters
DATEA date
TIMESTAMPDate and time
FLOATFloating point numbers
Run the tidy code silently


Specific to Access
MEMOAllows up to 65535 characters
CURRENCYSuitable for money.

Related links:

  • CREATE, DROP and ALTER