Page 1 of 1

delete check colum

Posted: Sat Mar 01, 2008 9:23 am
by alfredonan
i will be glad if i could be given any advice or example coding to delete a column from a table
eg this is the table
unique field fieldcolumn1 fieldcolumn2 feildcolumn3
111 <somedatat> <somedata> <somedata>


some if fieldcolumn1 is checked with a checkbox only that part should be deleted from the table without affecting the rest. more fields could be checked as well.

so the resulting table will look like:

unique field fieldcolumn1 fieldcolumn2 feildcolumn3
111 <deleted from table> <somedata> <somedata>


thank you

Re: delete check colum

Posted: Sat Mar 01, 2008 9:56 am
by hawkenterprises
ALTER TABLE table_name
ADD column_name datatype

ALTER TABLE table_name
DROP COLUMN column_name

Taken from w3schools.com