Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

how i can delete column from any table

program_agentprogram_agent Member Posts: 24
hi...
i wanna to know the sql statement that delete column from any table in any database in oracle 8i

plz answer me quickly ...thanx

Comments

  • tanveer haidertanveer haider Member Posts: 37
    hello,
    here r two way to do so.
    1-alter table tablename set unused col-name;
    alter table table-name drop unused columns;

    2-alter table table-name drop column salary;

    u can use these commands for Oracle8i and higher.

    take care
    tanveer haider

    : hi...
    : i wanna to know the sql statement that delete column from any table in any database in oracle 8i
    :
    : plz answer me quickly ...thanx
    :

  • program_agentprogram_agent Member Posts: 24
    hi.. thank you very much for your help.. but i try to use that statements but it not work ..plz plz check them..thanx again


    : hello,
    : here r two way to do so.
    : 1-alter table tablename set unused col-name;
    : alter table table-name drop unused columns;
    :
    : 2-alter table table-name drop column salary;
    :
    : u can use these commands for Oracle8i and higher.
    :
    : take care
    : tanveer haider
    :
    : : hi...
    : : i wanna to know the sql statement that delete column from any table in any database in oracle 8i
    : :
    : : plz answer me quickly ...thanx
    : :
    :
    :

  • infidelinfidel Member Posts: 2,900
    [b][red]This message was edited by infidel at 2004-11-29 8:43:35[/red][/b][hr]
    : hi.. thank you very much for your help.. but i try to use that statements but it not work ..plz plz check them..thanx again

    How is anyone out here supposed to check the problem with the statements in *your* database. Please don't be so foolish.


    [size=5][italic][blue][RED]i[/RED]nfidel[/blue][/italic][/size]

    [code]
    $ select * from users where clue > 0
    no rows returned
    [/code]



  • himanshu1984himanshu1984 Member Posts: 3
    hi,
    u can drop column from oracle9i only







    : hello,
    : here r two way to do so.
    : 1-alter table tablename set unused col-name;
    : alter table table-name drop unused columns;
    :
    : 2-alter table table-name drop column salary;
    :
    : u can use these commands for Oracle8i and higher.
    :
    : take care
    : tanveer haider
    :
    : : hi...
    : : i wanna to know the sql statement that delete column from any table in any database in oracle 8i
    : :
    : : plz answer me quickly ...thanx
    : :
    :
    :

  • ankaramankaram Member Posts: 5
    : hi...
    : i wanna to know the sql statement that delete column from any table in any database in oracle 8i
    :
    : plz answer me quickly ...thanx
    :
    hello here is the solution for your problem
    alter tablename drop columnname;
    if you get this command useful then reply me
  • ankaramankaram Member Posts: 5
    : hi...
    : i wanna to know the sql statement that delete column from any table in any database in oracle 8i
    :
    : plz answer me quickly ...thanx
    :
    alter table tablename drop columnname

  • anju119anju119 Member Posts: 4
    hi..
    no u can't ..... remember it belongs to DDL ....u can do one thing create a new table by selecting and copying only those cols u require... and then deleting the previous table from which u copied and then renaming the present table with the name which the deleted table had...
    byee
    -ana
    busy quering..........



    : hi...
    : i wanna to know the sql statement that delete column from any table in any database in oracle 8i
    :
    : plz answer me quickly ...thanx
    :

Sign In or Register to comment.