SQLzoo.net

CREATE a new table

SQL Server
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 SQL Server
The DATE type is not supported. Use DATETIME instead.

Related links:

  • CREATE, DROP and ALTER