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: Insufficient privileges.
The user account must be set up to permit tables to be created. Usually the database administrator must grant such permissions.
mysql variations:
Users must be granted CREATE on the database.
Possible error messages:
Error 1142: create command denied to user: '[email protected]' for table 't_test'

access
db2
mysql
oracle
postgres
sqlserver