A common problem
Increasing a VARCHAR column to the table: ALTER TABLE distributors ADD COLUMN address VARCHAR (30); the existing columns renamed: ALTER TABLE distributors RENAME COLUMN address TO city; the existing table renamed: ALTER TABLE distributors RENAME TO suppliers; increasing a to a table Foreign key constraints: Alter Table Distributors Add Constraint Distfk Foreign Key (Address) References Addresses (Address) Match Full