Breaking News: Grepper is joining You.com. Read the official announcement!

lister les index d'une table oracle

VasteMonde answered on May 6, 2021 Popularity 9/10 Helpfulness 7/10

answer lister les index d'une table oracle

lister les index d'une table oracle

Comment

SELECT *
FROM ALL_INDEXES			-- or DBA_INDEXES or USER_INDEXES
WHERE TABLE_NAME = 'MY_TABLE' AND OWNER = 'MY_OWNER';

-- Indexes columns
SELECT TABLE_NAME, INDEX_NAME, COLUMN_NAME
FROM DBA_IND_COLUMNS		-- or ALL_IND_COLUMNS
WHERE TABLE_OWNER = 'MY_OWNER' AND TABLE_NAME = 'MY_TABLE'
ORDER BY TABLE_NAME, COLUMN_POSITION;

Popularity 9/10 Helpfulness 7/10 Language sql

Source: Grepper

Tags: oracle select sql

Link to this answer
Share Copy Link

Contributed on May 06 2021

VasteMonde

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

lister les index d'une table oracle

Contents

More Related Answers

lister les index d'une table oracle

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.