SQL
zoo.net
CREATE a new table
SQLite
DB2
Ingres
Access
Postgres
Oracle
SQL Server
MySQL
Mimer
Sybase
Access
The following are examples of field types:
INTEGER
A whole number
VARCHAR(10)
Up to 10 characters.
CHAR(10)
Fixed number of characters
DATE
A date
TIMESTAMP
Date and time
FLOAT
Floating point numbers
Run the
tidy
code silently
CREATE TABLE t_test (a INTEGER PRIMARY KEY ,b VARCHAR(10) )
Specific to Access
MEMO
Allows up to 65535 characters
CURRENCY
Suitable for money.
Related links:
CREATE, DROP and ALTER
CREATE a new table
DROP an unwanted table
Composite primary key
CREATE a foreign key
CREATE a VIEW.
Create a table with an autonumber field (also known as sequence, identity)
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