delete columns sql table code example
Example 1: mssql remove column
ALTER TABLE table_name
DROP COLUMN column_name;
Example 2: sql delete column
Deletes a column from a table.
Example: Removes the first_name column from the users table.
ALTER TABLE users
DROP COLUMN first_name
Example 3: alasql delete column
var data = [{a:1,b:10},{a:2,b:20}];
var res = alasql('SELECT * REMOVE COLUMN b FROM ?',[data]);
// returns [{a:!},{a:2}]