Nigel Whitworth's Development Site

You are currently not logged in.

How do I delete a field in a table?

To delete a field from a table, you use the ALTER TABLE command as described below :-

     ALTER TABLE tblName
     DROP COLUMN name

So if you wish to delete the field Name from the table tblPeople you would use the following SQL statement

     ALTER TABLE tbl People
     DROP COLUMN Name      GO

If you intend to vote or make a comment, please enter the security code.

Make a comment

*Comments are the views of individuals, they may or may not be correct.
All comments are reviewed and accepted or rejected.
If you give an email address, you will be sent an email when someone makes a comment on this page.*

Name :
Email :
Comments :


Only name and Code is compulsory.
 
 
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)