Drop Column - MySQL Command

Definition: Drop column is used to remove a column from a given table. This also removes all data from the column. It is written as alter table drop column [column name];

Also Known As: MySQL Drop Column, Remove Column, Delete Column

Examples:

alter table icecream drop column flavor; 

This removes the column "flavor" from the table called "icecream".

Alter Table Commands

• Alter Table
• Add Column
• Change

Join the PHP Discussion

• Add Unique
• Modify
• 'Drop Column' Blog Entry

PHP with MySQL

• PHP & MySQL Message Board
• Accessing MySQL from PHP

MySQL Commands

• Add Column - MySQL Command
• Add Unique - MySQL Command
• Alter Table - MySQL Command
• Ceil - MySQL Command

Angela Bradley
PHP / MySQL Guide

• Sign up for My Newsletter

• Headlines
• Forum

See More About

• mysql commands
• mysql databases
• mysql tables

Top Related Searches alter table drop drop column column name

Explore PHP / MySQL

Must Reads

• Learn PHP
• Using PHP with MySQL
• Learn MySQL
• Create Email Forms
• PHP Login Script

Most Popular

• PHP Redirection
• Limit
• Ordering MySQL Data
• PHP Login Script
• PHP with HTML

By Category

• Learn PHP
• Learn MySQL
• Advanced PHP
• PHP with MySQL
• Graphics- GD Library
• Step By Steps
• PHP Functions
• MySQL Commands
• Security
• PHP/MySQL Basics
• Tools & Resoruces
• Troubleshooting
• Programing Glossary
• Reader Response
• Social Networking

PHP / MySQL

1. About.com
2. Computing
3. PHP / MySQL
4. MySQL Commands
5. SQL Drop Column - MySQL Drop Column - Drop Column

• Advertise on About.com
• Our Story
• News & Events
• SiteMap
• All Topics
• Reprints
• Help

• Write for About
• Careers at About
• User Agreement
• Ethics Policy
• Patent Info.
• Privacy Policy
• Your Ad Choices

©2013 About.com. All rights reserved.