indexes in MsAccess

From: hilz (no.w_at_y.com)
Date: 12/13/04

  • Next message: john martin: "hibernate and JDK 1.5" 
    Date: Mon, 13 Dec 2004 17:30:19 -0500

    Hi all. i know this is not directly related to java databases, but i thought
    this might be a good place to ask.
    I have a table in MsAccess that i created as follows:
    create table ITEM (
    ITEM_ID COUNTER PRIMARY KEY,
    ITEM_NAME CHAR(255) UNIQUE,
    ITEM_DESCRIPTION CHAR(255)
    )

    I need to drop the unique index on the ITEM_NAME, and i don't know its name.
    so how would i do that(using SQL).
    is there a way to get the names of all indexes on the table ITEM, and select
    the one i want?
    or is there another way to do that?

    thank you for any help.
    hilz

  • Next message: john martin: "hibernate and JDK 1.5"