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 :

1 comments:

  1. Hi There,


    Great info! I recently came across your blog and have been reading along.
    I thought I would leave my first comment. I don’t know what to say except that I have

    We have a linked server "LinkSQL" defined on SQLServerA against the same server, ie, SQLServerA and the server has Named Pipes disabled. Isn't communication among'st applications within one server happens primarily through Named Pipes. If so, would it be better if we have Named Pipes enabled on this SQLServer box?
    We are seeing intermittent TCP/Semaphore errors and I was wondering if enabling this option would help.
    But nice Article Mate! Great Information! Keep up the good work!


    Thank you,
    Danny

    ReplyDelete