Cacher is the code snippet organizer for pro developers

show databasename;
use databasename
show tables;
describe tablename;
alter table tablename drop column columnname;