How To Delete Column In SQL?

1

Use `ALTER TABLE table_name DROP COLUMN column_name;`

Example: `ALTER TABLE employees DROP COLUMN middle_name;`

For SQL Server, use `ALTER TABLE table_name DROP COLUMN column_name;`

For MySQL, use `ALTER TABLE table_name DROP COLUMN column_name;`

For PostgreSQL, use `ALTER TABLE table_name DROP COLUMN column_name;`

For Oracle, use `ALTER TABLE table_name DROP COLUMN column_name;`

To delete multiple columns, use `ALTER TABLE table_name DROP COLUMN col1, DROP COLUMN col2;`

Check for constraints, indexes, or dependencies before dropping the column