Tuesday, September 29, 2015

SQL

Removing column from Table:

Syntax:

 alter table <table_name> drop <col_name>;

Example:

ALTER TABLE student DROP column sdob;



















after dropping sdob column from student tale