Before using ALTER TABLE

Go Up to Altering Tables

Before modifying or dropping columns in a table, you need to do three things:

1. Make sure you have the proper database privileges.

2. Save the existing data.

3. Drop any constraints on the column.

Topics

• Saving Existing Data
• Dropping Columns