Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

Sign up Log in

CrazyEngineers powered by Jatra Community Platform

  • Kaustubh Katdare
    Kaustubh Katdare

    @thebigk • Apr 11, 2015

    Naresh ArshI have small query please give me solution for this.
    my query is i want to delete a column from a table .

    Right click on the column and select 'Delete'. It's very easy.

    0
  • Prasad Ajinkya
    Prasad Ajinkya

    @prasad-aSUfhP • Apr 14, 2015

    Know your DDL!

    Also Google!

    Alter table name drop column name;

    0
  • Neeraj Sharma
    Neeraj Sharma

    @neeraj-iAaNcG • Apr 18, 2015

    Naresh ArshI have small query please give me solution for this.
    my query is i want to delete a column from a table .

    ## Dropping one column
    ALTER TABLE table_name DROP COLUMN column_name;

    ##Dropping multiple columns
    ALTER TABLE table_name DROP COLUMN (column_name1, column_name2,...);

    0
  • Kaustubh Katdare
    Kaustubh Katdare

    @thebigk • Apr 18, 2015

    Too many assumptions here, right? 😁

    0
  • Neeraj Sharma
    Neeraj Sharma

    @neeraj-iAaNcG • Apr 18, 2015

    Kaustubh KatdareToo many assumptions here, right? 😁

    I didn't get you.. 😨

    0
  • Kaustubh Katdare
    Kaustubh Katdare

    @thebigk • Apr 18, 2015

    Neeraj SharmaI didn't get you.. 😨

    The original question does not talk about deleting a column from mysql database or excel or an HTML table. 😀 I just wish people could ask questions without making assumptions.

    0
  • Vishal Sharma
    Vishal Sharma

    @vishal-pysGmK • Apr 18, 2015

    Kaustubh KatdareThe original question does not talk about deleting a column from mysql database or excel or an HTML table. 😀 I just wish people could ask questions without making assumptions.

    We should probably wait for the #-Link-Snipped-# to return and clarify that. But i'm sure its not an excel table column or word table column 😁 And the right click, delete doesn't workout on HTML 😛

    0
  • Rahulkumar200
    Rahulkumar200

    @rahulkumar200-AzMcLQ • Apr 27, 2015

    Try this
    ALTER TABLE table_name
    DROP COLUMN column_name;

    0
  • Rahulkumar200
    Rahulkumar200

    @rahulkumar200-AzMcLQ • Apr 27, 2015

    And if you wanna !"add some columns"! try this
    ALTER TABLE table_name
    ADD column_name column-definition;

    0
  • Vishal Sharma
    Vishal Sharma

    @vishal-pysGmK • Apr 27, 2015

    Rahulkumar200Try this
    ALTER TABLE table_name
    DROP COLUMN column_name;

    already answered by #-Link-Snipped-#

    0