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
DATETIMEDate and time
FLOATFloating point numbers
Execute tidy up code silently


Specific to SQL Server
The DATE type is not supported. Use DATETIME instead.

Related links:

  • CREATE, DROP and ALTER