CrazyEngineers
CrazyEngineers

  • Delete a column from a table

    Naresh Arsh

    Member

    Updated: Oct 26, 2024
    Views: 1.3K
    I have small query please give me solution for this.
    my query is i want to delete a column from a table .
    0
    Replies
Howdy guest!
Dear guest, you must be logged-in to participate on CrazyEngineers. We would love to have you as a member of our community. Consider creating an account or login.
Replies

  • Kaustubh Katdare

    Administrator • Apr 11, 2015

    Naresh Arsh
    I 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.
    Are you sure? This action cannot be undone.
    Cancel

  • Prasad Ajinkya

    Member • Apr 14, 2015

    Know your DDL!

    Also Google!

    Alter table name drop column name;
    Are you sure? This action cannot be undone.
    Cancel

  • Neeraj Sharma

    Member • Apr 18, 2015

    Naresh Arsh
    I 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,...);
    Are you sure? This action cannot be undone.
    Cancel

  • Kaustubh Katdare

    Administrator • Apr 18, 2015

    Too many assumptions here, right? 😁
    Are you sure? This action cannot be undone.
    Cancel

  • Neeraj Sharma

    Member • Apr 18, 2015

    Kaustubh Katdare
    Too many assumptions here, right? 😁
    I didn't get you.. 😨
    Are you sure? This action cannot be undone.
    Cancel

  • Kaustubh Katdare

    Administrator • Apr 18, 2015

    Neeraj Sharma
    I 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.
    Are you sure? This action cannot be undone.
    Cancel

  • Vishal Sharma

    Member • Apr 18, 2015

    Kaustubh Katdare
    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.
    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 😛
    Are you sure? This action cannot be undone.
    Cancel

  • Rahulkumar200

    Member • Apr 27, 2015

    Try this
    ALTER TABLE table_name
    DROP COLUMN column_name;
    Are you sure? This action cannot be undone.
    Cancel

  • Rahulkumar200

    Member • Apr 27, 2015

    And if you wanna !"add some columns"! try this
    ALTER TABLE table_name
    ADD column_name column-definition;
    Are you sure? This action cannot be undone.
    Cancel

  • Vishal Sharma

    Member • Apr 27, 2015

    Rahulkumar200
    Try this
    ALTER TABLE table_name
    DROP COLUMN column_name;
    already answered by #-Link-Snipped-#
    Are you sure? This action cannot be undone.
    Cancel
Home Channels Search Login Register