CREATE TABLE problems: Invalid column name.

CREATE TABLE problems: Invalid column name.

schema:scott

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.

DROP TABLE t_wrong

CREATE TABLE t_wrong (when DATETIME)

CREATE TABLE t_wrong ([date] DATE)

CREATE TABLE t_wrong (date DATE)

You can get away with many of these in MySQL; don't do that!

Field names with spaces are permitted. You can use square brackets to get away with odd field names; don't do that!

Some reserved words cause a parse error.

You may not use DATE or SIZE or INDEX or NUMBER or ORDER or SIZE

as a field name.

CREATE and DROP Operations

CREATE a new table

DROP a table

Composite primary key

CREATE a foreign key

CREATE a VIEW

Autonumber fields

ALTER TABLE ... ADD COLUMN

ALTER TABLE ... DROP COLUMN

ALTER TABLE ... ADD constraint

CREATE TABLE problems: Invalid column name.

CREATE TABLE problems: Insufficient privileges.

CREATE TABLE problems: Table already exists.

DROP TABLE problems: Foreign key references.

CREATE TABLE problems: Foreign key references.

Rename column