Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2005
    Posts
    2

    Unanswered: Sybase ASE - How to drop index enclosed in double quotes?

    How to drop index enclosed in double quotes dynamically of updating the sysindexes adn rebooting the server?

    For example;
    TABLE_NAME."INDEX_NAME"

    Drop index TABLE_NAME."INDEX_NAME" doesn't work. It returns an error, Doesn't exist in system catalogs. 'TABLE_NAME."INDEX_NAME"'.

    Thanks,
    Kelvin

  2. #2
    Join Date
    Jun 2003
    Posts
    30
    Hi,

    You can try using,

    set quoted_identifier on
    go
    drop index table_name."index_name"
    go
    set quoted_identifier off
    go


    Regards,

    Virendra Deshpande.

  3. #3
    Join Date
    Feb 2005
    Posts
    2
    But it returns error message saying that it does not exist in the system catalogs. Any suggestions?

  4. #4
    Join Date
    Nov 2002
    Posts
    833
    sp_help table_name
    go

    is showing details for your particular table including indexes and their names

  5. #5
    Join Date
    Feb 2005
    Location
    Omaha, NE
    Posts
    83
    select user_name(uid), name
    from sysobjects where name = "TABLE_NAME"

    Most likely, you are not logged in as the owner of the table.

    set quoted_identifier on
    set user <tableowner>
    drop index TABLE_NAME."INDEX_NAME"

Posting Permissions

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