DROP TABLE problems: Foreign key references.

DROP TABLE problems: Foreign key references.

schema:scott

You may not drop a table if it is referenced by another table.

DROP TABLE t_b;
DROP TABLE t_a

CREATE TABLE t_a (i INTEGER NOT NULL PRIMARY KEY);
CREATE TABLE t_b (j INTEGER,
FOREIGN KEY(j) REFERENCES t_a(i));

DROP TABLE t_a

Foreign keys are not implemented in MySQL so this problem does not arise.

The CASCADE CONSTRAINTS clause can be used to remove the references.

DROP TABLE t_a CASCADE CONSTRAINTS

We can find out what the foreign keys are using sp_help table_name

The (implicit) trigger gets dropped automatically.

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