Update TABLE: ALTER, DROP, MODIFY

— ALTER TABLE TO  MODIFY A COLUMN — DROP A COLUMN ALTER TABLE TBL_EMPLOYEE DROP COLUMN Department; Add a Column ALTER TABLE TBL_DEPARTMENT ADD DEPARTMENT_HEAD VARCHAR(20 CHAR); Drop a Column — Assuming you have a table named “your_table” and you want to delete a column named “column_to_delete” ALTER TABLE your_table DROP COLUMN column_to_delete; DROP Multiple […]

Update TABLE: ALTER, DROP, MODIFY Read More »