Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Posts
    6

    Unanswered: Would I use an Index on a Table I already created to verifty uniqueness?

    I want to make sure that usernames and folder names (that are stored in the database) are all unique when created by the admin through an admin control panel.

    How would I code and use an Index to make sure that the 2 columns are unique?

    I've looked at examples on the net but nothing is telling me how I can create an index through Enterprise Manager? Thanks

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I rarely use Enterprise Mangler to create an index, but if you browse down the hierarchy to the table of interest, then right click and select all tasks, I'm pretty sure that "create index" is in that menu.

    Bear in mind that I almost never use Enterprise Mangler to create an index, so I might be a bit off!

    -PatP

  3. #3
    Join Date
    Oct 2003
    Posts
    706
    Quote Originally Posted by comn8u
    I want to make sure that usernames and folder names (that are stored in the database) are all unique when created by the admin through an admin control panel.

    How would I code and use an Index to make sure that the 2 columns are unique?
    How about a query like:
    SELECT username, foldername, count(*)
    FROM whatever
    GROUP BY username, foldername
    HAVING count(*) > 1
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

Posting Permissions

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