Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Tuesday, 3 October 2017

Drop Column in Oracle Table


Used to remove column from existing table
 
Syntax:
        Alter table <table_name> drop <col  datatype>;
Example:
ALTER TABLE student DROP COLUMN srno;
ALTER TABLE student DROP (phone,email);
Share this article :

0 comments:

Post a Comment