Results 1 to 3 of 3

Thread: Add drop columns in Sybase ASE 15.0

  1. 05-24-2008 #1
    keerthv
    keerthv is offline
    Junior Member
    Join Date
    Apr 2007
    Answers
    2

    Add drop columns in Sybase ASE 15.0

    I want to drop columns from a table using alter table.

    I have used alter table drop column

    This gives me syntax error.

    Can anyone please let me know how to add / drop columns to table in ASE 15.0

    Reply With Quote Reply With Quote
  2. 05-24-2008 #2
    Sanpri
    Sanpri is offline
    Junior Member
    Join Date
    Nov 2007
    Answers
    3

    Smile Re: Add drop columns in Sybase ASE 15.0

    Hi,

    The Syntax remains the same to add or drop a column.

    Alter table add/drop column

    we cannot drop a computed column.

    Thanks

    Reply With Quote Reply With Quote
  3. 12-02-2008 #3
    knagaokar
    knagaokar is offline
    Junior Member
    Join Date
    Dec 2008
    Answers
    1

    Smile Re: Add drop columns in Sybase ASE 15.0

    alter table table_name
    drop column_name
    go

    sp_recompile table_name
    go

    Last edited by knagaokar; 12-02-2008 at 01:06 PM. Reason: within <> not going in
    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

About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
GeekInterview
Interact