View source

From Kb

You do not have permission to do that, for the following reasons:

• The action you have requested is limited to users in the group user.
• You must confirm your e-mail address before editing pages. Please set and validate your e-mail address through your user preferences.

You can view and copy the source of this page:

> [[SQL_Query_Examples]] > Current Once a table has been created, you can make changes to it using the '''ALTER''' command. ==== 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 == [http://dev.mysql.com/doc/refman/5.0/en/alter-table.html Alter Table Syntax]

Return to SQL Alter Table.