A Gentle Introduction to

SQL

CREATE and DROP

How to create tables, indexes, views and other things. How to get rid of them.


CREATE a new table
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 (do not use this for money)
oracle variations:
CLOBAllows large character fields.
NUMBER(10,2)Up to 10 digits before the point, 2 after.


access
db2
mysql
oracle
postgres
sqlserver