A Gentle Introduction to

SQL

CREATE and DROP

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


CREATE TABLE problems: Invalid column name.

You may not use a reserved word as the name of a field. Many popular words are used by the system; some words to avoid...
date, day, index, number, order, size, year

SQL Reserved words

Having a "house-rule" can prevent such problems. Some developers insist that field names begin with fld for example fldSurname. Most of us have enough meaningless junk in their lives already; we don't need this kind of self imposed tyranny.

mysql variations:
You can get away with many of these in MySQL; don't do that!
Possible error messages:
Error 1064 You have an error in your SQL syntax

access
db2
mysql
oracle
postgres
sqlserver