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
Retrieved from "http://bluesunhosting.com/wiki/index.php/SQL_Alter_Table"