SQL Alter Table

From Kb

Jump to: navigation, search

> SQL_Query_Examples > Current

Once a table has been created, you can make changes to it using the ALTER command.

Contents

Delete a Column

  • ALTER TABLE TableName DROP COLUMN AuthorEMail

Change a Column

  • ALTER TABLE TableName MODIFY Column_Name tinytext

Add a New Column

  • ALTER TABLE TableName ADD Column_Name tinytext

Position a Column

Can be used with ADD, CHANGE, and MODIFY

  • {Alter Query} AFTER Colume_Name

Rename a Column

  • ALTER TABLE TableName CHANGE Old_Column_Name New_Column_Name columnType

MySQL Manual

Alter Table Syntax