new_table ADD COLUMN `column_name` INT(1) NOT NULL AFTER `after_this_column`"; //////////////////////// # Delete Column //////////////////////// global $wpdb; $sql = "ALTER TABLE $wpdb->new_table DROP column_name"; //////////////////////// # List Column names //////////////////////// global $wpdb; $db_name = DB_NAME; $table_name = "$wpdb->new_table"; $results = $wpdb->get_results(" SELECT COLUMN_NAME AS name FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = '$db_name' AND TABLE_NAME = '$table_name'; "); $column_names = array(); if(!empty($results)){ foreach($results as $result){ $column_names[] = $result->name; } } echo '

';
	print_r($column_names);
	echo '

'; ?>