SQLzoo.net

CREATE a table with an autonumber / sequence / identity / autoincrement

DROP TABLE t_test;
DROP sequence sq

Related links:

• CREATE a new table
• DROP an unwanted table
• Composite primary key
• Composite 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