FETCH TABLE NAMES WITH INDEX COLUMN NAMES

General

FETCH TABLE NAMES WITH INDEX COLUMN NAMES

Hi, 

  i have nearly 5000 tables in my DB, I want all the list of table names and primary index column names for those tables.

for all the tables there are Primary Index(may be on single or multiple columns), Can you please send me the sql statment to get reach my requirement 

1 REPLY
N/A

Re: FETCH TABLE NAMES WITH INDEX COLUMN NAMES


You can find your info in
dbc
.indicesv

Rglass