Results 1 to 3 of 3

Thread: SQL - Tables

  1. Aug 21st, 2001, 03:46 AM #1
    DaveR
    DaveR is offline

    Thread Starter
    Hyperactive Member DaveR's Avatar
    Join Date
    Mar 2001
    Location
    Ireland
    Posts
    268

    Question SQL - Tables

    Hi All,
    I want to write a sql script that will remove a column from a table.
    The table is full of data , so i dont want to drop the table and recreate it.
    I've seen some syntax such as
    alter table jobs drop jobname
    but it doesnt seem to work either.
    I think this is only for dropping constraints.

    If any one has any ideas , send them on.
    Thanks
    dave
    DaveR
    Reply With Quote Reply With Quote
  2. Aug 21st, 2001, 06:36 AM #2
    pankajagarwal
    pankajagarwal is offline
    Junior Member
    Join Date
    Aug 2001
    Location
    India
    Posts
    17
    if you are using access then syntex is ok.
    if you are using personal oracle then this syntex will not work due to privalage is not there. This syntex will work on oracle 8i.

    pankaj
    Reply With Quote Reply With Quote
  3. Aug 21st, 2001, 08:09 AM #3
    EricW
    EricW is offline
    Junior Member
    Join Date
    Aug 2001
    Location
    Netherlands
    Posts
    19
    which database are you running?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width