Results 1 to 2 of 2

Thread: index

  1. #1
    Join Date
    Feb 2004
    Posts
    19

    Unanswered: index

    Hi,
    i am new to oracle.i have a basic doubt.
    if i have EMP table,how will i know the primarykey,foreignkey,indexes on that table.
    if i want to drop them ,how will i drop them.

    Thanks
    kk

  2. #2
    Join Date
    May 2004
    Location
    Pune, India
    Posts
    15
    hi
    check out the data dictionary views USER_INDEXES, user_CONSTRAINTS, and user_CONS_COLUMNS, and user_IND_COLUMNS. the first 2 views wud give the general dtails regarding hte index/constrtaints. but if there are composite indexes/constraints the next 2 wud give u the details regarding each column, htat columns posotion in the index/constraint adn all such details.
    regards
    abhivyakti

Posting Permissions

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