hello, can anybody help me how can i delete table name. for example :-
table foo (age tinyint(3), name varchar(30)); so i want to delete the field age.
tq
ALTER TABLE foo DROP age
foo
age
Note: what you want is to drop a column, not a table.
A database contains tables, and tables contain columns.
in your example, foo is a table, and age is a column.