CREATE a new table

CREATE a new table

schema:scott

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

DROP TABLE t_test

CREATE TABLE t_test
 (a INTEGER NOT NULL PRIMARY KEY
 ,b VARCHAR(10)
 )

CREATE TABLE t_test
 (a INTEGER PRIMARY KEY
 ,b VARCHAR2(10)
 )

CREATE TABLE t_test
 (a INTEGER PRIMARY KEY
 ,b VARCHAR(10)
 )

MEMO	Allows up to 65535 characters
CURRENCY	Suitable for money.

The DATE type is not supported. Use DATETIME instead.

CLOB	Allows large character fields.
NUMBER(10,2)	Up to 10 digits in total, including 2 after the decimal point.

TEXT	Allows up to 65535 characters
DECIMAL(10,2)	Up to 10 digits in total, including 2 after the decimal point.

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